Ranking

D

dg

Hi

I am trying to get excel to rank scores and then I will use a lookup to get
the highest rank, however my scores have ties and sometimes have 2 first
places and 2 second places. Is there anyway to get excel to simply take the
top5 numbers of a range and to rank them say 1st, 1st, third, third, fifth?

thanks

doug
 
Top