彙整 扣除移出 加入移入 (12377)

G2{=IFERROR(INDIRECT(TEXT(RIGHT(SMALL(IF({1,0},IF(COUNTIF(D:D,B$2:B$9)=0,2*10001+ROW($2:$9)/1%),IF(E$2:E$9<>"",5*10001+ROW($2:$9)/1%)),ROW(A1)),4),"!R0C00"),),"")



留言