Thank you Rick - It works as I hoped for.
Mel

"Rick Rothstein" wrote in message
...
You can use the RANK function. Assuming your numbers are in A1:A100, put
this formula in B1 and copy down...

=RANK(A1,A$1:A$100)

--
Rick (MVP - Excel)


"shakey" wrote in message
...
I have a column of around 25 numbers ranging in value from 0 to 50 with
some duplications. I would like the next column to show their order IE:
highest number is listed as 1 next highest 2, etc. I do NOT want to sort
the numbers into increasing value. Would be nice but not necessary if ties
would carry same result number.
23 - 2
46 - 1
11 - 3
22-3
etc.
Is their a formula to do this in Excel standard 2007?
Thank you
Mel