Hi guys,
been trying to fix my problem for the last couple of days but weren't able to do so...
My worksheet looks like the following:
I'm using a macro which calls other macros depending on a data validation list selection. The macro looks like the following:
I'm counting all 'X' in row 7 beginning from column D to the last column (which is AF in my case). All columns without an 'X' are hidden.
It works as indented but a formula in my sheet gives me headache. It's this one:
I'm calculation the percentage of occuring 'X' and 'O' with it. The problem starts when I use the macro to hide some columns (which aren't marked with 'X') as the percentage stays the same -> it's still calculating it for all existing columns.
What I wanted to achieve is a changing percentage based on the amount of VISIBLE columns. I tried to use sumproduct and subtotal but always ended up with #ref! or #value! errors, such as this one:
Hope you can guide me to the right direction
Thanks in advance.
Cheers,
Mike
Bookmarks