(先)N2:O14{=IFERROR(INDIRECT(TEXT(RIGHT(SMALL(IF((A$2:G$2=N$1)*($A$3:$G$16<>""),ROW($3:$16)/1%+COLUMN(A:G)*10001),ROW(A1)),4),"!R0C00"),),"")
M2:M14{=IF(N2="","",IF(INDEX($1:$1,SUM((A$3:G$16=N2)*MOD(COLUMN(A:G),2)*COLUMN(A:G)))=LOOKUP(1,0/(M$1:M1<>""),M$1:M1),"",INDEX($1:$1,SUM((A$3:G$16=N2)*MOD(COLUMN(A:G),2)*COLUMN(A:G)))))
留言
張貼留言