Not corrupted did a new one and still does not give me what I want
They way I want it to rank is as follows.
Rank Number
1 -360
2 -250
3 75
4 50
5 22
6 9
7 4.5
8 .06
9 0
As you can see the most negative number is the highest rank. and once
positve the higher the positive number the higher the rank
--
Tim
"bj" wrote:
It woeks fine on my computer
if you put in a -360 and a plus 360 what do you get for a rank?
If you close out of Excel and restart and on a new sheet put you numbers
what do you get.
I think you have at least a corrupted worksheet. Hopefully your Excel
master is not corupted.
"Tim Sullivan" wrote:
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
|