E
Ed from AZ
In Col A, I have a drop-down (data validation) of five items. In Col
B, I need to put a number that is a running total of how many times
the item in Col A has been selected. So it would look like:
Col A Col B
A 1
A 2
A 3
B 1
B 2
A 4
A 5
C 1
C 2
D 1
D 2
D 3
A 6
B 3
Is there a formula I can use?
Ed
B, I need to put a number that is a running total of how many times
the item in Col A has been selected. So it would look like:
Col A Col B
A 1
A 2
A 3
B 1
B 2
A 4
A 5
C 1
C 2
D 1
D 2
D 3
A 6
B 3
Is there a formula I can use?
Ed