H2=INDEX(B:B,SMALL(IF(MMULT(N($C$2:$F$5<>""),{1;1;1;1})>={1,2,3,4},{2;3;4;5},99),ROW(A1)))&""
I2=IF(H2="","",VLOOKUP(H2,B:F,COUNTIF(H$2:H2,H2)+1,))
K2:L12{=INDIRECT(TEXT(SMALL(IF($C$2:$F$5<>"",{2;3;4;5}/1%+IF(H$1=$I$1,{3,4,5,6},2),9999),ROW(A1)),"!R0C00"),)&""
留言
張貼留言