I need to allocate an incremental number to a cell in the Count column based on one of three options typed into the Item cell adjacent as follows:
Item Count
A 1
B 1
C 1
A 2
B 2
A 3
and so on
can anyone help?