Hello,
I need a little help with a problem using excel Rank and Vlookup.
My spread sheet has 4 columns and 288 rows.

( Players A2 ) (Account #B2) ( Credits C2 ) ( Ranking D2)
John Smith 2020 100 1
Pual Johnson 2021 90 2
Steve Steel 1011 100 1

I rank the Players using "=Rank(c2,c2:c4)" in column D and Vlookup to pull
the data from the table above into a top 29 winner list. However, when there
is a tie (D2 and D4), Vlookup never finds the A4 player but returns A2
Player. I am trying to find a set of forumla that will automatically sort
for me. That will keep me from hand sorting a "top 29 Winners" list.

Any Ideals?

--
dan61021