Hi,
I'm trying to number a column in sequential order by counting the number of times a certain word is typed in another range.
For example:
AAA 1
BBB 1
AAA 2
AAA 3
CCC 1
I need the numbers to be in sequence in column B:B every time a word is typed multiple times in column A:A.
Hope this makes sense.
Thanks,
Marzocchi