Hi Jon,

Try,

In D2 and copy across and down,

=INDEX($A$1:$C$1,MATCH(LARGE($A2:$C2,COLUMN(A1)),$ A2:$C2,0))

where A1:C1 houses Game 1, Game 2 and Game 3.

HTH


--
Krishnakumar


------------------------------------------------------------------------
Krishnakumar's Profile: http://www.excelforum.com/member.php...o&userid=20138
View this thread: http://www.excelforum.com/showthread...hreadid=496358