S2:S18{=OFFSET(A$1,SMALL(IF(B$2:Q$4>0,{1;2;3},99),ROW(A1)),)&""
T2:T18{=IF(S2="","",OFFSET(A$1,,SMALL(IF(VLOOKUP(S2,A:Q,COLUMN(B:Q),)>0,COLUMN(A:P)),COUNTIF(S$2:S2,S2))))
U2:U18{=IF(S2="","",RIGHT(SMALL(IF($B$2:$Q$4>0,({1;2;3}/1%+COLUMN(B:Q))*10^4+B$2:Q$4),ROW(A1)),4)*1)
二列一公式T2:U18{=IFERROR(INDIRECT(TEXT(RIGHT(SMALL(IF($B$2:$Q$4>0,{2;3;4}/1%%+{2;3;4}^(A$1=$B$1)/1%+COLUMN($B:$Q)),ROW(A1)),4),"!R0C00"),),"")
留言
張貼留言