G
Gemz
Hi,
Hope u can help me with the below:
I have a spreadsheet which is exported from a system with a whole lot of 0’s
that don’t need to be there.
So, the condition is – if the contents of C3 down, D3 down, E3 down etc
contains ALL 0 then delete entire column. The spreadsheet spans from about C3
to AH onwards (however the spreadsheet can grow smaller or bigger at any time
so its not good to specify an end column). I need to have this for all the
columns i.e. F3 down, G3 down etc etc.
So, all i want it to do is look from cell 3 downwards in each column and if
the contents of each column it is ALL 0 then to delete the entire column.
I hope this is making sense, what i want isn’t so hard but its not easy to
say it!
Thanks for help.
Hope u can help me with the below:
I have a spreadsheet which is exported from a system with a whole lot of 0’s
that don’t need to be there.
So, the condition is – if the contents of C3 down, D3 down, E3 down etc
contains ALL 0 then delete entire column. The spreadsheet spans from about C3
to AH onwards (however the spreadsheet can grow smaller or bigger at any time
so its not good to specify an end column). I need to have this for all the
columns i.e. F3 down, G3 down etc etc.
So, all i want it to do is look from cell 3 downwards in each column and if
the contents of each column it is ALL 0 then to delete the entire column.
I hope this is making sense, what i want isn’t so hard but its not easy to
say it!
Thanks for help.