Forum Discussion
Formula help - Ranking each value in a range by closeness to Mean.
Hi, I need some help with a formula. I have a range of values in cells I4:I227 In column J4:J227, I need a formula that will rank each value in I4:I227 by it's closeness to the Mean value. I ...
= LET(
mean, AVERAGE(values),
deviation, ABS(values - mean),
SORTBY(values, deviation, -1)
)This sort of calculation is natural within the context of Excel 365 array thinking, but laboured in legacy systems.