B8:C17{=IFERROR(INDIRECT(TEXT(RIGHT(SMALL(IF($C$2:$E$5<>"",{2;3;4;5}^(B$1=$C$1)/1%+{3,4,5}*10001),ROW(A1)),4),"!R0C00"),),"")
二列分開B8:B17{=INDEX($1:$1,SMALL(IF(MMULT({1,1,1,1},N(C$2:E$5<>""))>=ROW($1:$9),{3,4,5},99),ROW(A1)))&""
二列分開C8:C17{=IF(B8="","",OFFSET(B$1,SMALL(IF(C$1:E$1=B8,ROW($1:$4)),COUNTIF(B$8:B8,B8)),MATCH(B8,C$1:E$1,)))
留言
張貼留言