M6 =IF(L6,LOOKUP(L6,SUBTOTAL(9,OFFSET(N$1,,,{1,2,3}))+1,{"正取","備取",""}),"")
ML089 發表於 2016-7-29 19:21
回復 kaui700
M6 =IF(L6="","",LOOKUP(L6,SUBTOTAL(9,OFFSET(N$1,,,{1,2,3}))+1,{"正取","備取","" ...
ML089 發表於 2016-7-29 22:52
歡迎光臨 麻辣家族討論版版 (http://forum.twbts.com/) |