Put this formula in E2 and copy down to create a unique "key":

=(B2&"."&C2&D2)*1

Put this formula in F2 and copy down for the ranking:

=RANK(E2,$E$2:$E$5)


===========
'RANK-TIEBREAKING - here's a bunch more techniques and methods for dealing with tie-break ranking:(the file you want is Rank-TieBreaking.xls)

http://www.excelforum.com/excel-prog...-tables.html#2
http://www.excelforum.com/attachment...iebreaking.xls