Excel Numbering using existing column data

Hi all,
Using an already existing spreadsheet with 10,000 columns of data.
In the first column it has the names of items but multiple times (ex: item1, item1, item2, item2, item2, item3, item3, item3, item3, etc.)
I would like a way to create the sequential numbers in another column. In regards to the example.
Item1 returns 1
Item1 returns 2
Item2 returns 1
Item2 returns 2
Item2 returns 3
Item3 returns 1
Item3 returns 2
Item3 returns 3
Item3 returns 4

Is there a route to take to do this auto-numbering per the column data? Please message me with any questions your assistance is much appreciated!

Thanks

Do you mean 10,000 Rows of data?

Here is a macro that will do what you want. It assumes that your data is in Column A and that Column B is blank.

Please Login or Register  to view this content.

Originally Posted by Haseeb A

=COUNTIF(A$2:A2,A2)

Very nice

(plus these extra characters required to allow me to make this post)