How to set counter to identical values in list of data?
Posted by mabaud on December 31, 2000 12:22 AM
I have to following list of data in column a:
111
112
111
111
112
113
I would like, in column B to have a counter of the identical values , ie:
1
1
2
3
2
1
Thanks for your help
mabaud
Posted by Aladin Akyurek on December 31, 2000 2:17 AM
=COUNTIF($a$1:a1,a1)
Copy down as far as needed.
Aladin
