sirdef:

Since I brought up the topic of tie scores, I thought I'd take a shot
at handling them....

With your data in A1:B5

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

E1: Name
E2:
=INDEX($A$2:$A$5,SUMPRODUCT(MATCH(SUMPRODUCT(LARGE ($B$2:$B$5+0.001*ROW($B$2:$B$5),D2)),$B$2:$B$5+0.0 01*ROW($B$2:$B$5),0)))

Copy that formula down through E4

ANOTHER ALTERNATIVE....Pivot Table
If you use a Pivot Table, then you can:
Right-Click on the Name field
Check: Advanced Options
Select: Show Top 3

Does either of those options help?

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