The ABS came up. The problem is a -250 should be ranked higher than +250,
using ABS they are equal. The -250 Should be ranked higher than the +250. If
there were a +300 thrown into the mix the ranking needs to be in this order,
-250,300,250
--
Tim


"SVC" wrote:

I tried wwhat you did and got the same result.

One possible solution: You could create a dummy column with the absolute
value of your number (=ABS(XX)), then rank the absolute values. If you don't
want to see the column of absolute values, hide the column.

"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