software

What formula should I use in Column C to return the % figures in Column C?

This formula in Column C should rank in percent the numerical rank in Column
B for Each Label indicated in Column A.

For example, in the first row below, it shows that 4 in Col B is in the top
57% of the 7 Xs in Col A. The manual formula is =4/7.

Could you also explain generally what the sumproduct formula that should be
used with this is doing in English? Thanks a lot!

Col A Col B Col B
X457%
X7100%
X229%
X114%
X571%
X686%
X343%
XX4100%
XX250%
XX125%
XX375%
XXX114%
XXX343%
XXX686%
XXX457%
XXX7100%
XXX229%
XXX571%
XXXX250%
XXXX375%
XXXX4100%
XXXX125%
You don't need SUMPRODUCT

If these values start in row 2 and go down to row 25, then in col C use

=B2/COUNTIF($A$2:$A$25,a2)

quot;SteveCquot; wrote:

gt; What formula should I use in Column C to return the % figures in Column C?
gt;
gt; This formula in Column C should rank in percent the numerical rank in Column
gt; B for Each Label indicated in Column A.
gt;
gt; For example, in the first row below, it shows that 4 in Col B is in the top
gt; 57% of the 7 Xs in Col A. The manual formula is =4/7.
gt;
gt; Could you also explain generally what the sumproduct formula that should be
gt; used with this is doing in English? Thanks a lot!
gt;
gt; Col A Col B Col B
gt; X457%
gt; X7100%
gt; X229%
gt; X114%
gt; X571%
gt; X686%
gt; X343%
gt; XX4100%
gt; XX250%
gt; XX125%
gt; XX375%
gt; XXX114%
gt; XXX343%
gt; XXX686%
gt; XXX457%
gt; XXX7100%
gt; XXX229%
gt; XXX571%
gt; XXXX250%
gt; XXXX375%
gt; XXXX4100%
gt; XXXX125%
gt;
gt;

Hi Steve,

Try:
=B1/COUNTIF(A:A,A1)
in C1 and copy down as far as needed. I can't see any need for a SUMPRODUCT
solution.

For an explanation of the COUNTIF function, input the formula and click on
the 'Paste function' icon on the toolbar.

Cheers

quot;SteveCquot; gt; wrote in message
...
gt; What formula should I use in Column C to return the % figures in Column C?
gt;
gt; This formula in Column C should rank in percent the numerical rank in
Column
gt; B for Each Label indicated in Column A.
gt;
gt; For example, in the first row below, it shows that 4 in Col B is in the
top
gt; 57% of the 7 Xs in Col A. The manual formula is =4/7.
gt;
gt; Could you also explain generally what the sumproduct formula that should
be
gt; used with this is doing in English? Thanks a lot!
gt;
gt; Col A Col B Col B
gt; X 4 57%
gt; X 7 100%
gt; X 2 29%
gt; X 1 14%
gt; X 5 71%
gt; X 6 86%
gt; X 3 43%
gt; XX 4 100%
gt; XX 2 50%
gt; XX 1 25%
gt; XX 3 75%
gt; XXX 1 14%
gt; XXX 3 43%
gt; XXX 6 86%
gt; XXX 4 57%
gt; XXX 7 100%
gt; XXX 2 29%
gt; XXX 5 71%
gt; XXXX 2 50%
gt; XXXX 3 75%
gt; XXXX 4 100%
gt; XXXX 1 25%
gt;
gt;
Thank you very much!

Great! Thanks.