Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a column with 24 numbers. I want to rank them. Using the standard
rank function works fine until one of the numbers is a negative. They way I want it to rank is as follow Rank Number 1 -360 2 -250 3 75 4 50 5 22 6 9 7 4.5 8 .06 9 0 The higher then negative number, the higher the rank. A negative number is ranked higher than a positive number. A low positive number is ranked lower than a high positive number. Does this make sense????????? Any help wopuld be appreciated -- Tim Sorry about the duplicate post in another area -- Tim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Numbers used for Ranking | Excel Worksheet Functions | |||
Ranking Using Grand Total | Excel Discussion (Misc queries) | |||
Ranking | Excel Discussion (Misc queries) | |||
ranking an row of values | Excel Worksheet Functions | |||
Problem with ranking numbers | Excel Worksheet Functions |