Hi

I have a spreadsheet which you can view he

http://www.mediafire.com/?en2ywr1tjs8

If you go to the 'Gary Results' Tab, you will see that in cells C3:C5 it is
pulling 'Rhydian Roberts' through 3 times from the 'Gary Scores' Tab.
However, this is not what I intend to happen, as I would like Rhydian Roberts
to be in cell C3, Niki Evans in cell C4 and then Hope in cell C5, as they all
scored 10; with the rest following suit.

This used to work in Excel XP but I'm now using Excel 2007 and it doesn't
seem to work (I think because of the change in the 'Rank' formula).

Is there a formula that I can enter into cells C3:C14 in the 'Gary Results'
tab that will pull through the appropriate person in the correct order?


Regards