View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default listing winners formula


sirdef:

Here's something to work with....

With your list in A1:B5

D1: Place
D2: 1
D3: 2
D4: 3

E1: Name
E2: =INDEX($A$1:$A$5,MATCH(LARGE($B$1:$B$5,D1),$B$1:$B $5,0))
Copy that formula down through E4

Note: that formula cannot differentiate tie scores. If that is an
issue let us know.

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=548615