Have this solution

then

need get like this

5653247890344.xlsm
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.

Business Systems Analyst , ex-Senior Application EngineerCommented:
do you mean to populate columns C, D and E using Excel formula?

can you provide logic to calculate the percentage in column C?
ACCOUNTING 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
ACCOUNTING 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
ACCOUNTING ASSISTANTAuthor Commented:
because 8 sets of 10 toral columns  * 100 = 80% for row 4 like example
Business Systems Analyst , ex-Senior Application EngineerCommented:
ok, for column D: Total Columns, I would apply this formula:

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

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

=COUNTA(G4:DS4)

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

=E4/D4

see if this solved your issue?
5653247890344_b.xlsm

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.

Business Systems Analyst , ex-Senior Application EngineerCommented:
btw, for column C, i just format it instead of multiple it by 100. hence, you can do necessary amendment when necessary.
ACCOUNTING ASSISTANTAuthor Commented:
Great JOB !
Great Expert !
ACCOUNTING 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)
Business Systems Analyst , ex-Senior Application EngineerCommented:
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)
ACCOUNTING ASSISTANTAuthor Commented:
Ryan Chong

formula (A/B ) is not needed
ACCOUNTING ASSISTANTAuthor Commented:
Ryan Chong

where in the code can be fixed

E/D is the corrected needed
ACCOUNTING ASSISTANTAuthor Commented:
this the file need the correction
65434677665v1--2-_43532.xlsm
Business Systems Analyst , ex-Senior Application EngineerCommented:

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

ACCOUNTING ASSISTANTAuthor Commented:
Ryan Chong

you rigth great expert
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.