[算表] 求現在庫存均價,以先進出現概念反推
軟體: excel
版本: 2010
問題 : 每個品項,先進先出概念,反推現在庫存是由哪幾筆入庫均價組成
由於總筆數約1000多筆自己也思考了1天,無法得出,想請教是否有公式可得出解。
附件如下:
http://ppt.cc/HLl2
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 111.253.55.129
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1423311280.A.6A5.html
推
02/08 00:53, , 1F
02/08 00:53, 1F
→
02/08 00:59, , 2F
02/08 00:59, 2F
→
02/08 03:08, , 3F
02/08 03:08, 3F
→
02/08 20:42, , 4F
02/08 20:42, 4F
→
02/08 20:44, , 5F
02/08 20:44, 5F
→
02/08 20:46, , 6F
02/08 20:46, 6F
→
02/08 20:47, , 7F
02/08 20:47, 7F
→
02/08 20:58, , 8F
02/08 20:58, 8F
→
02/08 23:21, , 9F
02/08 23:21, 9F
→
02/08 23:26, , 10F
02/08 23:26, 10F
→
02/08 23:26, , 11F
02/08 23:26, 11F
→
02/08 23:31, , 12F
02/08 23:31, 12F
→
02/08 23:34, , 13F
02/08 23:34, 13F
→
02/08 23:43, , 14F
02/08 23:43, 14F
→
02/08 23:50, , 15F
02/08 23:50, 15F