G
Guest
I could do this manually, but it would take me forever. Is there a
program/formula that could be written to automatically find the Individual
Job percentages - column C?? The variable to this equation is that the number
of Individual Jobs varies. And how to refer to the correct company total?
-------------
Column A = Company Name
Column B = Total Sales amount for the company followed by Individual Job
amounts (which add up to the Total Sales). The number of Individual Jobs can
vary.
Column C = Individual Job percentage of the company's Total Sales. See the
example below.
A B C
XYZ Total 485,000
XYZ 265,000 55%
XYZ 150,000 31%
XYZ 55,000 11%
XYZ 15,000 3%
ABC Total 800,500
ABC 500,000 62%
ABC 300,000 37%
JKL Total 1,400
JKL 500 36%
JKL 400 29%
JKL 300 21%
JKL 200 14%
JKL 100 7%
JKL 50 4%
Thank you in advance!!
program/formula that could be written to automatically find the Individual
Job percentages - column C?? The variable to this equation is that the number
of Individual Jobs varies. And how to refer to the correct company total?
-------------
Column A = Company Name
Column B = Total Sales amount for the company followed by Individual Job
amounts (which add up to the Total Sales). The number of Individual Jobs can
vary.
Column C = Individual Job percentage of the company's Total Sales. See the
example below.
A B C
XYZ Total 485,000
XYZ 265,000 55%
XYZ 150,000 31%
XYZ 55,000 11%
XYZ 15,000 3%
ABC Total 800,500
ABC 500,000 62%
ABC 300,000 37%
JKL Total 1,400
JKL 500 36%
JKL 400 29%
JKL 300 21%
JKL 200 14%
JKL 100 7%
JKL 50 4%
Thank you in advance!!