Excel: counter column


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.

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
Thanks Dave


This question generated 31 answers. To proceed to the answers, click here.

This thread is current as of April 19, 2014.


For more resources for Microsoft Excel