第1 ,2高分数引用左边數據 (10372)

K2{=IF(J2="","",OFFSET(A$1,RIGHT(LARGE(IF(B$1:F$1=J2,B$2:F$10/1%+ROW($1:$9)),COUNTIF(J$2:J2,J2)),2),MATCH(J2,$1:$1,)-2))

另解{=IF(J2="","",OFFSET(A$1,RIGHT(LARGE(OFFSET(A$2:A$10,,MATCH(J2,$1:$1,)-1)/1%+ROW($2:$10),COUNTIF(J$2:J2,J2)),2)-1,MATCH(J2,$1:$1,)-2))

格式化A2:E10=(COUNTIF(B:B,">"&B2)<2)*(MOD(COLUMN(A1),2)=1)