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.
and invoke in C2...
Or, without an additional range, invoke: