Sorry ... complete aberation ..
should be

=rank(d2,d2:d11)

d2 will contain =COUNTIF($B$2:$B$500,"sales")
d3 will contain =COUNTIF($B$2:$B$500,"finance")

etc

Again, my apologies.

"tonystowe" wrote:


Toppers Wrote:
Assuming D2 to D11 contains the counts (COUNTIF($B$2:$B$500,"<office"),
then
you could use:

=RANK(COUNTIF($B$2:$B$500,"sales"),D2:D11)

Or if D2 contains Sales count

=RANK(COUNTIF(D2,D2:D11)

HTH



Thanks for your reply. I could not get the =Rank(countif(d2,d2:d11) to
work as an error message indicating too few arguments pops up.

While =RANK(COUNTIF($B$2:$B$500,"sales"),D2:D11) did work with only
"SALES" as its que, how do I make it rank sales when I have other
offices such as shipping, receiving, orders, etc. I do account for ALL
offices and for the formula to rank each as the reports are added?

Thanks


--
tonystowe
------------------------------------------------------------------------
tonystowe's Profile: http://www.excelforum.com/member.php...o&userid=33162
View this thread: http://www.excelforum.com/showthread...hreadid=530202

[/color]