各科第一名次數 (9199)

K2=SUMPRODUCT(N(SUBTOTAL(4,OFFSET(A$2:A$7,,COLUMN(A:I)))=B2:J2))

格式化 B2:J7=COUNTIF(B$2:B$7,">"&B2)=0