Carry running total for various items?

[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

 

[Rick Rothstein \(MVP - VB\)]

Assuming your first value is in Row 1...

=COUNTIF(A$1:A1,A1)

Rick

 

[JP]

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

 

[JP]

Sorry, Rick's formula is correct.

 

[Ed from AZ]

Thank you, Rick!! Greatly appreciated!

Ed

Assuming your first value is in Row 1...

=COUNTIF(A$1:A1,A1)

Rick








- Show quoted text -