15minoffame
Board Regular
- Joined
- Nov 26, 2014
- Messages
- 55
Hi,
I have ones & zeros in column C. Is there a formula that will show me a streak of alternate ones & zeros like at the bottom where there's six in a row?
Thank you!
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>
I have ones & zeros in column C. Is there a formula that will show me a streak of alternate ones & zeros like at the bottom where there's six in a row?
Thank you!
C | |
1 | 0 |
2 | 0 |
3 | 0 |
4 | 1 |
5 | 0 |
6 | 0 |
7 | 1 |
8 | 0 |
9 | 0 |
10 | 0 |
11 | 1 |
12 | 0 |
13 | 0 |
14 | 0 |
15 | 0 |
16 | 1 |
17 | 0 |
18 | 1 |
19 | 0 |
20 | 1 |
21 | 0 |
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>