Auto numbering in excel

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.

Sequential Numbering in Excel Sheets. Sheet 1 - Copy to Sheet 2 But No in Cell "A1" must Change to next No I.e 0001 to 0002.

Is there a way within Excel to Auto Generate a new number every time I open a spreadsheet.ie: I made a Purcahse Order template and I would like for Excel to generate a new Purchase Order number whenever I open it up. Can anyone let me know if this is a possibility.

I have an existing excel spreadsheet, & I want to go back in, create another column, & automatically number it, starting at 1 & going on sequentially. According to the help, I started the numbering, 1,2,3 & used the FILL command (down). It then changes all the highlighted cells to 1! I can number...