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.
The formula worked, although it put them in order from descending rather than ascending. Can you explain how the formula actually works in case I need to modify it? Thanks for your help.
Great. Thanks. Can you tell me what the 0 and 1 do at the end of the formula?