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