指定科目前 5名 提出 (11192)

B2下拉{=INDEX(F:F,RIGHT(LARGE(OFFSET(A$2,,MATCH(A$2,$1:$1,)-1,98,)/1%%+ROW($2:$99),ROW(A1)),2))

格式化 G2:J16=(COUNTIF(G$2:G$16,">"&G2)<5)*($A$2=G$1)

L2下拉=OFFSET(F$1,,ROW(A5)/5)&""

M2下拉{=INDEX(F:F,RIGHT(LARGE(OFFSET(A$2,,MATCH(L2&"",$1:$1&"",)-1,28,)/1%%+ROW($2:$29),COUNTIF(L$2:L2,L2)),2))&""

M2下拉=IF(L2="","","第 "&MOD(ROW(A1)-1,5)+1&" 名")