If I have a column with a repetitive series of text items, how can I get a counter that shows the number of times that text has already shown up?
I.e. How can I get this?
A 1
A 2
B 1
C 1
A 3
B 2
If I have a column with a repetitive series of text items, how can I get a counter that shows the number of times that text has already shown up?
I.e. How can I get this?
A 1
A 2
B 1
C 1
A 3
B 2
I think a COUNTIF() with a mix of absolute for the beginning of the address and relative for the end, and copying down.
=COUNTIF($A1:A1;A1)
Thank you very much!!! Absolutely perfect and simple! Quoting a wise man: “Make everything as simple as possible, but not simpler.” - Albert Einstein
Gracias Miguel Ángel
Good mention, specially useful with spreadsheet.
Não tens de quê Pedro.