RANK ABSOLUTE NUMBER AND WITHOUT GAP
Hi,
If you pull the absolute value out to another column
=ABS(A2)
and drag down then you can use this formula
=SUMPRODUCT(--(A2$A$2:$A$8),1/COUNTIF($A$2:$A$8,$A$2:$A$8&""))+1
I'm sure it can be done without a helper column but I can't see it for the
moment.
Mike
"M&M" wrote:
The value that I need to rank include positive and negative number. I need
to treat them all absolute value and also need to rank without gap.
VALUE RANK RESULT
-15 6
14 5
13 4
-12 3
-10 2
9 1
-9 1
Any ideas?
--
M&M
|