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