Assume A1:A9 is your data, try this:

B1 =
RANK(A1,A$1:A$9,1)+IF(A1=0,2*(COUNTIF(A$1:A$9,"0 ")-RANK(A1,A$1:A$9,1)),0)


Hope it helps.




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


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=388021