Have a look at different ways of ranking data - here's a link to Chip
Pearson's site:

http://www.cpearson.com/excel/rank.htm

Hope this helps.

Pete