Carry running total for various items?

  • Thread starter Thread starter Ed from AZ
  • Start date Start date
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
 
Assuming your first value is in Row 1...

=COUNTIF(A$1:A1,A1)

Rick
 
Let's say your data starts in A1, put this formula in B2 and fill
down:

=COUNTIF($A$1:$A2,A2)

You can't use it in B1, however.

--JP
 
Back
Top