# percent based in total columns

need the percent as show here
needed

29078870aaaaa.xlsm
Microsoft OfficeVBAMicrosoft Excel

Last Comment

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

Martin

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

decimals could be
Martin Liss

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

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'?

Martin

is good  09.25%
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.

Working !! great !

how i can clean the HIST_DTA??

could be an clean button ?