B. Baumgartner Wrote:
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)
--
Paul Sheppard
------------------------------------------------------------------------
Paul Sheppard's Profile:
http://www.excelforum.com/member.php...o&userid=24783
View this thread:
http://www.excelforum.com/showthread...hreadid=396992