Trying to Rank positive numbers in ascending order & negative numbers in descending order I’m trying to rank Payroll hours % used for my stores and we consider closest to 0 the best, the more you save which leads to a bigger saving % is worse but overspending (which is a negative %) is worst. I've tried this formula in excel but it's not quite what i need. ...
https://www.excelforum.com/sho....wthread.php?t=142175