Formula to Rank and populate values based on Rank

[Ecel Dumbo]

Hello Dear Friends,


Please look in the attached file and please advise a formula to rank the values and to populate figures based on the rank.


Thanks


File Attachment link below


http://speedy.sh/pAXMc/Ranking-Query.xls

 

[Hui]

Ecel Dumbo


I'd do the following


Delete Rows 13 & 14

C2: =RANK.EQ(B2,$B$2:$B$15)

Copy C2 down

A25: put 1

A26: put 2

A27: put 3

A28: put 4

I2: =IF(C2>4,"",VLOOKUP(C2,$A$25:$C$28,3))

Copy I2 down


I'm unsure what Column F is about?