排名 依每人指定名次 (13965)

M2:M16{=INDEX(A:A,RIGHT(LARGE(RIGHT(SMALL(B$2:I$16/1%+ROW(2:16)*10^6+ROW($2:$16),ROW($1:$15)*8-K$2+1),6)*1,ROW(A1)),2))

M2:M16另解{=INDEX(A:A,RIGHT(LARGE(IF(RANK(B$2:I$16,OFFSET(B$1:I$1,ROW($1:$15),))=K$2,B$2:I$16/1%+ROW($2:$16)),ROW(A1)),2))

N2:N16{=LARGE(VLOOKUP(M2,A:I,COLUMN(B:I),),K$2)

B2;I16每人名次格式化=RANK(B2,$B2:$I2)=$K$2