B2{=IFERROR(INDEX(IF({1,0},表1!A$2:A$16,表2!A$2:A$16),INT(MIN(IF((COUNTIF(B$1:B1,IF({1,0},表1!A$2:A$16,表2!A$2:A$16))=0)*(IF({1,0},表1!A$2:A$16,表2!A$2:A$16)>0),ROW($1:$15)/1%+{1,2},4^8))%),RIGHT(MIN(IF((COUNTIF(B$1:B1,IF({1,0},表1!A$2:A$16,表2!A$2:A$16))=0)*(IF({1,0},表1!A$2:A$16,表2!A$2:A$16)>0),ROW($1:$15)/1%+{1,2})),2)),"")
F2:G2 下拉=INDIRECT("表"&COLUMN(A1)&"!A"&ROW(A2))&""
C2 下拉{=INDIRECT(TEXT(MIN(IF((COUNTIF(C$1:C1,F$2:G$14)=0)*(F$2:G$14<>""),ROW($2:$14)/1%+{6,7},4^8)),"!R0C00"),)&""
留言
張貼留言