Insert numbers in a column based on the data in another column

[reganomics18]

Hello -

I am trying to find a way to insert numbers into a column based on the data in another column and am stumped. Example below:

image1.JPG

As you can see, I've numbered the third column to go in sequential order based on the first column - every time the number in the first column changes, the sequence starts at one again. Basically, I'd like to insert numbers in the third column in the same way all the way down (30K rows) using a formula or some excel formatting that I am not familiar with and not in the manual format of hand typing them in. Is anyone able to help? It would be much appreciated.

Thanks,

Ashley

[micope21]

Hi

Welcome to the forum.

Please click the attachment.
Hope this what you looking for?

[Cutter]

In C2 and copied down:

=IF(A2="","",COUNTIF(A$2:A2,A2))

this is very likely the same formula provided by micope21, I haven't looked.

[reganomics18]

Thank you both - this formula works!