I have a series of numbers in separated cells (ie m11, ac11, bd11), some are negative some are positive. I want to rank them based on their absolute value, or distance from zero. The ranking formula I am using is:
=RANK.EQ(M11,($M11,$AI11,$BE11,$CA11,$CW11,$DS11,$EO11,$FK11,$GG11,$HC11,$HY11,$IU11,$JQ11,$KM11,$LI11,$ME11,$NA11,$NW11,$OS11,$PO11,$QK11,$RG11,$SC11,$SY11),1). When I add ABS to each of the cell references the formula stops working. Anyone have any ideas? I have to do this 30 or 40 times in the workbook I'm using, so I would love something simple.
=RANK.EQ(M11,($M11,$AI11,$BE11,$CA11,$CW11,$DS11,$EO11,$FK11,$GG11,$HC11,$HY11,$IU11,$JQ11,$KM11,$LI11,$ME11,$NA11,$NW11,$OS11,$PO11,$QK11,$RG11,$SC11,$SY11),1). When I add ABS to each of the cell references the formula stops working. Anyone have any ideas? I have to do this 30 or 40 times in the workbook I'm using, so I would love something simple.
