H2{=INDEX(B:B,SMALL(IF(C$2:F$5<>"",{2;3;4;5},99),ROW(A1)))&""
I2{=IFERROR(INDEX($1:$1,RIGHT(SMALL(IF(C$2:F$5<>"",{1;2;3;4}/1%+{3,4,5,6}),ROW(A1)),2)),"")
另解I2{=INDEX($1:$1,SMALL(IF((B$2:B$5=H2)*(C$2:F$5<>""),{3,4,5,6},99),COUNTIF(H$2:H2,H2)))&""
J2{=IFERROR(INDIRECT(TEXT(SMALL(IF($C$2:$F$5<>"",{2;3;4;5}/1%+{3,4,5,6}),ROW(C1)),"!R0C00"),),"")
留言
張貼留言