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

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.

Formula in the second column is
=COUNTIF($A$1:A1,A1)

Slight correction to Darkthorne's formula, in case the formula gets copied to the right:

=COUNTIF($A$1:$A1, $A1)