How to use rank and ABS functions to rank the set of + and - numbers to be
ranked from 0 and up regardless +ve or -ve number:
A B C
Data Take
ABS Value Ranked succesfully
Formula =ABS(A2) =RANK(B2,(B$3:B$14),(0.01))
-1.00 1 1
10.00 10 8
13.00 13 10
18.00 18 11
23.00 23 12
8.98 8.98 6
9.00 9 7
-5.00 5 2
-11.00 11 9
-7.00 7 4
5.55 5.55 3
-8.97 8.97 5
------------------
foloowing formula did not work: gave error as "# NA"
=RANK((ABS(A3)),(A$3:A$14),1)
-----------------------------
Please help to solve above formula in oreder to avoid adding an colum to
calcualte the ABS value and hide it from an table.

Or give any other suggestions.

Thanking you in advance.

I think this formula will produce the result you want. It assumes your data
starts in Row 3 (as your example seems to indicate)...

=SUMPRODUCT(--(ABS(A$3:A$14)<ABS(A3)))+1

Rick


"KP" wrote in message
...
How to use rank and ABS functions to rank the set of + and - numbers to be
ranked from 0 and up regardless +ve or -ve number:
A B C
Data Take
ABS Value Ranked succesfully
Formula =ABS(A2) =RANK(B2,(B$3:B$14),(0.01))
-1.00 1 1
10.00 10 8
13.00 13 10
18.00 18 11
23.00 23 12
8.98 8.98 6
9.00 9 7
-5.00 5 2
-11.00 11 9
-7.00 7 4
5.55 5.55 3
-8.97 8.97 5
------------------
foloowing formula did not work: gave error as "# NA"
=RANK((ABS(A3)),(A$3:A$14),1)
-----------------------------
Please help to solve above formula in oreder to avoid adding an colum to
calcualte the ABS value and hide it from an table.

Or give any other suggestions.

Thanking you in advance.