MrJones378
New Member
- Joined
- Nov 12, 2015
- Messages
- 5
Okay so I think I've exhausted my googling/foruming options trying to figure this out. I've found a ton of things that are very close to this problem but not quite the same. I'm pretty certain I'm going to need an array formula. Essentially I have data that looks like this:
<tbody>
</tbody>
Now the data set I'm using is a good amount larger but not enormous (approx. 160 rows). What I need is to count the number of times "0" occurs consecutively. In this case, 0 would have occurred consecutively 3 times, on the 2nd and 3rd, on the 5th and 6th, and the 6th and 7th. I have another cell (lets say D4) that needs a formula that will count the number of times a 0 occurred on consecutive days.
Many thanks in advance for any insight.
Date | Numb |
1/1 | 2 |
1/2 | 0 |
1/3 | 0 |
1/4 | 1 |
1/5 | 0 |
1/6 | 0 |
1/7 | 0 |
<tbody>
</tbody>
Now the data set I'm using is a good amount larger but not enormous (approx. 160 rows). What I need is to count the number of times "0" occurs consecutively. In this case, 0 would have occurred consecutively 3 times, on the 2nd and 3rd, on the 5th and 6th, and the 6th and 7th. I have another cell (lets say D4) that needs a formula that will count the number of times a 0 occurred on consecutive days.
Many thanks in advance for any insight.