Avatar of ADRIANA P
ADRIANA P
Flag for United States of America asked on

percent based in total columns

need the percent as show here
needed

222222222222222222222222222222222222.PNG29078870aaaaa.xlsm
Microsoft OfficeVBAMicrosoft Excel

Avatar of undefined
Last Comment
ADRIANA P

8/22/2022 - Mon
Martin Liss

What should the percent be in C3?
Martin Liss

I'm guessing that this is what you want. Note that in the last row of HIST_DTA 20/43 is actually .4651... Do you want to see any decimals like 46.5 or is 47 what you want?
29078876.xlsm
ADRIANA P

ASKER
Martin

Do you want to see any decimals like 46.5 or is 47 what you want?

decimals could be
Your help has saved me hundreds of hours of internet surfing.
fblack61
Martin Liss

decimals could be
Does that mean yes you want decimals? If so how many?
ADRIANA P

ASKER
Martin
2 places could be
Martin Liss

OK, final question.

For percents less than 10, would you rather see something like '09.25' or  something like '9.25'?
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
ADRIANA P

ASKER
Martin  

is good  09.25%
ASKER CERTIFIED SOLUTION
Martin Liss

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
ADRIANA P

ASKER
Working !! great !

how i can clean the HIST_DTA??
ADRIANA P

ASKER
could be an clean button ?
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
ADRIANA P

ASKER
Great Job!  Best Expert!!