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 everytime a word is typed multiple times in column A:A.

Hope this makes sense.
Thanks,
Marzocchi

walt17

I think I understand what you want to do. But...it is going to be extremely difficult and complex to do so in Excel. You really need to switch to a database program for something like that.