Hi all,

Trying to figure out the "Rank" function and not doing well.
I have a column of data formated as % and would like to see what the rank
each one is without sorting them assending. If some one can just explain the
use of the rank function I would appreciate it. Unless of course there is a
better way!
xl2k
130.64% 2
167.39% 10
187.91% 14
139.48% 6
130.86% 3
126.51% 1
203.13% 15
139.04% 5
214.37% 16
181.59% 11
185.17% 13
182.76% 12
257.97% 17
165.81% 8
133.17% 4
166.64% 9
142.08% 7

I did this the "HARD" way and still not real confident they are right. Need
a formula.

Mike R.