[算表] excel average 多個搜尋條件後的值
軟體: office
版本: 2013
https://drive.google.com/file/d/0B93MGIxKfJMpbEllQ1RzeUZPbVE/view?usp=sharing
如附檔。
從另兩個sheet 導入值到 "EFF" sheet ,
目的是每日只要將更新的'針車' '成型' 頁面貼上去
就可以自動生成eff
每日的數據欄位固定 列位會有變化
所以這是要用 average+vlookup嗎?
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 123.30.98.177
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1481689925.A.1CE.html
→
12/14 13:02, , 1F
12/14 13:02, 1F
→
12/14 13:03, , 2F
12/14 13:03, 2F
→
12/14 14:22, , 3F
12/14 14:22, 3F
→
12/14 14:28, , 4F
12/14 14:28, 4F
→
12/14 14:30, , 5F
12/14 14:30, 5F
→
12/14 14:30, , 6F
12/14 14:30, 6F
→
12/14 14:36, , 7F
12/14 14:36, 7F
→
12/14 14:36, , 8F
12/14 14:36, 8F
→
12/14 14:36, , 9F
12/14 14:36, 9F
→
12/14 14:37, , 10F
12/14 14:37, 10F
→
12/14 18:04, , 11F
12/14 18:04, 11F
→
12/14 18:05, , 12F
12/14 18:05, 12F
→
12/14 18:12, , 13F
12/14 18:12, 13F
→
12/14 18:12, , 14F
12/14 18:12, 14F
→
12/14 18:19, , 15F
12/14 18:19, 15F
→
12/14 18:19, , 16F
12/14 18:19, 16F
→
12/14 18:19, , 17F
12/14 18:19, 17F
→
12/14 18:19, , 18F
12/14 18:19, 18F
→
12/14 19:15, , 19F
12/14 19:15, 19F
Office 近期熱門文章
PTT數位生活區 即時熱門文章
