Rank based on Totals

  • Thread starter Thread starter B. Baumgartner
  • Start date Start date
B

B. Baumgartner

I have a spreadsheet that tallies numbers per month for different
categories. I tally the totals on the 13th column. What I want to do
is create a function that then ranks these scores from 1 to 1000
(arbitrary) based upon the score (low to high). For example, the
category whose total is closest to 0 should be ranked 1 and so on.

Can someone recommend a function?

Thanks
 
B. Baumgartner said:
I have a spreadsheet that tallies numbers per month for different
categories. I tally the totals on the 13th column. What I want to do
is create a function that then ranks these scores from 1 to 1000
(arbitrary) based upon the score (low to high). For example, the
category whose total is closest to 0 should be ranked 1 and so on.

Can someone recommend a function?

Thanks
Click to expand...

Try this in column 14

=RANK(m1,m:m,1)
 
Back
Top