ranking a list of numbers above or below the average

  • Thread starter Thread starter Debbie
  • Start date Start date
D

Debbie

I've used the "rank" function to rank each number in my
list, however I need to compare against the average number
of the list and rank as +1, +2, -1, -2, etc.
How can I adjust my formula in the cell to add this
requirement?
Thanks in advance!
 
Debbie,

Let's say you have your list in A1:A10. In A11, enter the formula
=Average(A1:A10)
Then in B1, enter the formula
=RANK(A1,$A$1:$A$11,TRUE)-RANK($A$11,$A$1:$A$11,TRUE)
and copy down to B2:B10.

HTH,
Bernie
MS Excel MVP
 
Back
Top