PDA

View Full Version : Sequential numbering in Excel


marzocchi
Feb 5, 2005, 09:32 AM
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

walt17
Feb 15, 2005, 04:53 PM
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.

Darkthorne
Oct 22, 2012, 12:51 PM
Formula in the second column is
=COUNTIF($A$1:A1,A1)

JBeaucaire
Oct 27, 2012, 11:02 PM
Slight correction to Darkthorne's formula, in case the formula gets copied to the right:

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