How to order numbers

S

shakey

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
 
R

Rick Rothstein

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)
 
S

shakey

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

Rick Rothstein said:
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)
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding the proper style field and the numbered paragraph value within the style 0
Merging from an Excel file with graphics 1
Page numbering with Merged Document and IF statements 1
Finding the right style field in VBA 0
How can the font and size of (all) citation numbers be altered? 1
Insert Index into a Table 1
Number Match Formula? 7
Macro storing as a date? 11

Top