重複箱號 找出 (13154)

D2{=IFERROR(SMALL(IF(MMULT((TRANSPOSE(LEFT(B$2:B$12,FIND("--",B$2:B$12&"--")-1))-ROW($1:$399)<=0)*(TRANSPOSE(ABS(RIGHT(B$2:B$12,3)))-ROW($1:$399)>=0),ROW(1:11)^0)>1,ROW($1:$399)),ROW(A1)),"")



留言