SQUIDD
Well-known Member
- Joined
- Jan 2, 2009
- Messages
- 2,107
- Office Version
- 2019
- 2016
- Platform
- Windows
Hi
I am trying to create a counter in column C.
Like this the counter counts from 1-8 only if column A has data. It resets if column B has data to 1 and starts over.
<tbody>
</tbody>
Thanks
Dave
I am trying to create a counter in column C.
Like this the counter counts from 1-8 only if column A has data. It resets if column B has data to 1 and starts over.
A | B | C | D | E | F | G | H | I | |
1 | 2 | 1 | |||||||
2 | 3 | 2 | |||||||
3 | 6 | 3 | |||||||
4 | 1 | 4 | |||||||
5 | 4 | 5 | |||||||
6 | 1 | 6 | |||||||
7 | 4 | 7 | |||||||
8 | 2 | 8 | |||||||
9 | |||||||||
10 | |||||||||
11 | 4 | 3 | 1 | ||||||
12 | |||||||||
13 | 4 | 5 | 1 | ||||||
14 | 2 | 2 | |||||||
15 | 5 | 3 | |||||||
16 | 3 | 4 | |||||||
17 | |||||||||
18 | 6 | 5 | |||||||
19 |
<tbody>
</tbody>
Thanks
Dave