Archive of Mr Excel Message Board
Back to Forms in Excel VBA archive index
Back to archive home
Using the =RANK(R5,R$5:R$36)*1
Posted by Knight Coach on January 23, 2002 6:35 AM
I am using the formula =RANK(R5,R$5:R$36)*1 to sort figures
Column R is a number, and is sorted highest to lowest.
Therefore, the highest number gets 1, lowest gets 32.
Now I have a column that is sorted lowest to highest,
and I need to use the rank formula to assign the lowest
number (1) to the lowest cell rather than the highest.
When I try to do use the above RANK formula, it goes
opposite...assigns the sorted column's highest mark to the
lowest point.
HELP!?! What am I doing wrong?
| Check out our Excel Resources
|
 |
 |
=RANK(R5,R$5:R$36,1) [nt]
Posted by Mark W. on January 23, 2002 6:58 AM
Check your 1/28 18:01 posting (NT)
Posted by Tom Dickinson on January 23, 2002 7:53 AM
THANKS TOM!
Posted by Knight Coach on January 23, 2002 9:30 AM
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.