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

[/color]

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