Rank based on Totals

[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

 

[Paul Sheppard]

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

Try this in column 14

=RANK(m1,m:m,1)