查找各校名次考号 (10287)

G2:H3=OFFSET(A$1,LOOKUP(1,0/(COUNTIFS($B:$B,$B$2:$B$16,$C:$C,">"&$C$2:$C$16)=$F2-1)/($B$2:$B$16=$E2),ROW($1:$15)),COLUMN(A1)-1)

另解=LOOKUP(1,0/(COUNTIFS($B:$B,$B$2:$B$16,$C:$C,">"&$C$2:$C$16)=$F2-1)/($B$2:$B$16=$E2),OFFSET(A$2:A$16,,COLUMN(A1)-1))