Create a 2nd range of data with ABS...I am trying to rank a set of percentages that are positive and negative. I would like to treat the negative values as positive and rank accordingly. I can not figure out which formula to use. Please help.

=ABS(A2)

and invoke in C2...

=RANK(B2,$B$2:$B$25)

Or, without an additional range, invoke:

=SUMPRODUCT((ABS($A$2:$A$15)>ABS(A2))+0)+1

## Like this thread? Share it with others