Formula to rank scores that contain ties

[The_Snook]

Morning all,

I have some bidder scores that I need to rank but I'm struggling to account for the tied scores.

Example attached.

Thanks in advance,

Snook

[kvsrinivasamurthy]

IN D2 then drag down

=LARGE($C$3:$L$3,B7)

ARRAY formula in C2 then drag down

=INDEX($C$2:$L$2,SMALL(IF($C$3:$L$3=D7,COLUMN($C$2:$L$2),""),COUNTIF($D$7:$D7,D7))-COLUMN($C$2)+1)

[Glenn Kennedy]

Alternative, non-array (ordinary) formula in C2:

=INDEX($2:$2,SMALL(INDEX(($C$3:$L$3<>D7)*10^10+COLUMN(C$3:L$3),0),COUNTIF(D$7:D7,D7)))

[The_Snook]

Bob on, thanks both.

Snook