Riddlemethis
New Member
- Joined
- Apr 20, 2021
- Messages
- 14
- Office Version
- 2013
- Platform
- Windows
So I've a column AA with a load of helper cells in it with equals to "1" indicating the start of a new 'workload' however the type of workload is dictated by the number of gaps in the column until the next 1.
I need a way to use maybe COUNTBLANK or other method but only to sum the number of blanks until the next 1 and return the value in the next column. The '1' is always in a variable cell depending on the data that is inserted that day which is where I'm struggling. Is this possible?
Image attached has blank count manually typed in AB for an example of what I'm looking.
I need a way to use maybe COUNTBLANK or other method but only to sum the number of blanks until the next 1 and return the value in the next column. The '1' is always in a variable cell depending on the data that is inserted that day which is where I'm struggling. Is this possible?
Image attached has blank count manually typed in AB for an example of what I'm looking.