How to order numbers
 

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

How to order numbers
 

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

How to order numbers
 

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

How to order numbers
 

Thank you Works great and even takes care of the same score aspect.
Mel

"Jim Thomlinson" wrote in message
...
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

How to order numbers
 

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