software

Here is the run down:

Col A = Date - Self explanatory
Col B = Office - This column will list the same 10 offices multiple
times as
reports indicate.
Col C = Report - This column will show the details reported on an
specific
office.

In Col D I am using =COUNTIF($B$2:$B$500,quot;Salesquot;) in order to count the
number of instances that SALES is entered into Col B.

Problem

I want to use the RANK function to look at the cell Counting the number
of instances of quot;SALESquot; and RANK it in comparison to the number of times
the other offices have been listed.

If its possible to combine these two functions into one cell that would
be even better.

--------------------

Thanks before hand for anyone interested in helping me with this
problem.

Tony--
tonystowe
------------------------------------------------------------------------
tonystowe's Profile: www.excelforum.com/member.php...oamp;userid=33162
View this thread: www.excelforum.com/showthread...hreadid=530202Assuming D2 to D11 contains the counts (COUNTIF($B$2:$B$500,quot;lt;officegt;quot;), then
you could use:

=RANK(COUNTIF($B$2:$B$500,quot;salesquot;),D211)

Or if D2 contains Sales count

=RANK(COUNTIF(D2,D211)

HTH

quot;tonystowequot; wrote:

gt;
gt; Here is the run down:
gt;
gt; Col A = Date - Self explanatory
gt; Col B = Office - This column will list the same 10 offices multiple
gt; times as
gt; reports indicate.
gt; Col C = Report - This column will show the details reported on an
gt; specific
gt; office.
gt;
gt; In Col D I am using =COUNTIF($B$2:$B$500,quot;Salesquot;) in order to count the
gt; number of instances that SALES is entered into Col B.
gt;
gt; Problem
gt;
gt; I want to use the RANK function to look at the cell Counting the number
gt; of instances of quot;SALESquot; and RANK it in comparison to the number of times
gt; the other offices have been listed.
gt;
gt; If its possible to combine these two functions into one cell that would
gt; be even better.
gt;
gt; --------------------
gt;
gt; Thanks before hand for anyone interested in helping me with this
gt; problem.
gt;
gt; Tony
gt;
gt;
gt; --
gt; tonystowe
gt; ------------------------------------------------------------------------
gt; tonystowe's Profile: www.excelforum.com/member.php...oamp;userid=33162
gt; View this thread: www.excelforum.com/showthread...hreadid=530202
gt;
gt;


Toppers Wrote:
gt; Assuming D2 to D11 contains the counts (COUNTIF($B$2:$B$500,quot;lt;officegt;quot;),
gt; then
gt; you could use:
gt;
gt; =RANK(COUNTIF($B$2:$B$500,quot;salesquot;),D211)
gt;
gt; Or if D2 contains Sales count
gt;
gt; =RANK(COUNTIF(D2,D211)
gt;
gt; HTH
gt;
gt; gt;[/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,quot;salesquot;),D211) did work with only
quot;SALESquot; 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: www.excelforum.com/member.php...oamp;userid=33162
View this thread: www.excelforum.com/showthread...hreadid=530202Sorry ... complete aberation ..
should be

=rank(d2,d2:d11)

d2 will contain =COUNTIF($B$2:$B$500,quot;salesquot;)
d3 will contain =COUNTIF($B$2:$B$500,quot;financequot;)

etc

Again, my apologies.

quot;tonystowequot; wrote:

gt;
gt; Toppers Wrote:
gt; gt; Assuming D2 to D11 contains the counts (COUNTIF($B$2:$B$500,quot;lt;officegt;quot;),
gt; gt; then
gt; gt; you could use:
gt; gt;
gt; gt; =RANK(COUNTIF($B$2:$B$500,quot;salesquot;),D211)
gt; gt;
gt; gt; Or if D2 contains Sales count
gt; gt;
gt; gt; =RANK(COUNTIF(D2,D211)
gt; gt;
gt; gt; HTH
gt; gt;
gt; gt; gt;
gt;
gt; Thanks for your reply. I could not get the =Rank(countif(d2,d2:d11) to
gt; work as an error message indicating too few arguments pops up.
gt;
gt; While =RANK(COUNTIF($B$2:$B$500,quot;salesquot;),D211) did work with only
gt; quot;SALESquot; as its que, how do I make it rank sales when I have other
gt; offices such as shipping, receiving, orders, etc. I do account for ALL
gt; offices and for the formula to rank each as the reports are added?
gt;
gt; Thanks
gt;
gt;
gt; --
gt; tonystowe
gt; ------------------------------------------------------------------------
gt; tonystowe's Profile: www.excelforum.com/member.php...oamp;userid=33162
gt; View this thread: www.excelforum.com/showthread...hreadid=530202
gt;
gt;[/color]


Thanks while I couldn't figure that out on my own it is beginning to
make sense. Again, Thanks

Tony--
tonystowe
------------------------------------------------------------------------
tonystowe's Profile: www.excelforum.com/member.php...oamp;userid=33162
View this thread: www.excelforum.com/showthread...hreadid=530202