Have a look in HELP index for LARGE

--
Don Guillett
SalesAid Software

"Dave H" wrote in message
...
I am running a competition that will be using Excel to calculate scores.
I
am looking for a way to search the total score column, pull out the
highest
3 scores and place them in a Results table. I then need to pull out the
contestant's name and place it next to their pulled score.

I want the table to look like this:

Place: Contestant: Total Sco
1st Pulled from table Max score from col
2nd Pulled from table 2nd highest score
3rd Pulled from table 3rd highest score

Any help would be greatly appreciated

Thanks
Dave