Hi, I want to do the follow for a sheet i am creating in Excel.
The image below shows the hours row showing 1-11 but when i hide columns 3&4 it needs to show like the bottom row. So in effect adding +1 to previous cell but ignore hidden cells if that makes sense.
The image below shows the hours row showing 1-11 but when i hide columns 3&4 it needs to show like the bottom row. So in effect adding +1 to previous cell but ignore hidden cells if that makes sense.