Formula to generate Serail numbers based on group count

[excelsishya]

Hi all,

I am in need of dynamic formula which generates serial numbers based on group count.

Could anyone help with formula or link to same if formula is already posted here ?

customer names
A
A
A
B
C
C
D
D
D

These are there in column A staring from A2

Desired Result in Column B

A 1
A 2
A 3
B 1
C 1
C 2
D 1
D 2
D 3

Currently i am using non dynamic method.


Where i will use countif in column b (starting at b2) and in c column (starting at c2) logical formula to check if b2=b3 then i filter column c for true and selecting visible cell in column b i delete counif numbers.

now i left with blanks at column b at true juncture now i filter blanks in col b go to last visible cell uses last cell value mines 1 to get result

I guess there must be better way of doing this could any one post dynamic formula?

Thanks

 

[Peter_SSs]

I can't make sense of your description of what you are doing now, but just looking at the desired results, doe this formula (copied down) not do what you want?

Excel Workbook
	A	B
1	A	1
2	A	2
3	A	3
4	B	1
5	C	1
6	C	2
7	D	1
8	D	2
9	D	3
10
Serial Numbers

 

[excelsishya]

Yes Peter that was what i wanted.

Thanks