Take a look at the rank function in XL...

=rank(a1, $A$1:$A$10, 0)

--
HTH...

Jim Thomlinson


"shakey" wrote:

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