Adjust Percent

Have this solution

then


need get like this

090909090990909090909090909090909909.PNG5653247890344.xlsm
ADRIANA PACCOUNTING ASSISTANTAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ryan ChongCommented:
do you mean to populate columns C, D and E using Excel formula?

can you provide logic to calculate the percentage in column C?
1
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Ryan Chong

Thanks for the fast reponse

what i mean is  coumn E is the portion of column D

sets is the percent od total columns
thats the correction needed


rigth now is num percent of count  that wrong
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
the corrected formula in the code should be

example row 4   ==   sets 8 / total columns 10 * 100 = 80%

that the correction needed in the code
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
because 8 sets of 10 toral columns  * 100 = 80% for row 4 like example
0
Ryan ChongCommented:
ok, for column D: Total Columns, I would apply this formula:

=OFFSET($F$3,0,SUMPRODUCT(MAX((G4:DS4<>"")*COLUMN(G4:DS4)))-6)

Open in new window


then for column E, SETS, I would try this piece of formula:

=COUNTA(G4:DS4)

Open in new window


at last, for column C, % i would simply use column E / Column D

=E4/D4

Open in new window


see if this solved your issue?
5653247890344_b.xlsm
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ryan ChongCommented:
btw, for column C, i just format it instead of multiple it by 100. hence, you can do necessary amendment when necessary.
1
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Great JOB !
Great Expert !
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Ryan Chong

column D  and column E

have the data i alredy need that comes from   V_OUT


but column C is computing alredy % from  column A /B

but whats  I Need is column  E/D

but need that in the code because the code have the worng formula (A/B)
0
Ryan ChongCommented:
but whats  I Need is column  E/D

but need that in the code because the code have the worng formula (A/B)

you probably can't save "memory" in the Excel file, so you got to: create another column for the correct percentage formula in case you want to remain the wrong formula in column C (A/B)
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Ryan Chong

formula (A/B ) is not needed
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Ryan Chong

where in the code can be fixed

E/D is the corrected needed
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
this the file need the correction
65434677665v1--2-_43532.xlsm
0
Ryan ChongCommented:

E/D is the corrected needed
isn't that in the sample file I uploaded contain the correct formula?

0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Ryan Chong

you rigth great expert
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.