Labeling Duplicate data in a column

[hanahass]

Hi Masters!

Seeking your expertise to help me with this if i have, for example :

A
A
A
B
B
C
C
D
D
D

and I need the next to be labelled as their order from top to bottom like the image attached

Not sure if this is confusing but, please let me know.

Thanks in advance!

 

[Peter_SSs]

Like this?

21 08 31.xlsm
	A	B
1	A	1
2	A	2
3	A	3
4	B	1
5	B	2
6	C	1
7	C	2
8	D	1
9	D	2
10	D	3
Number Them

Cell Formulas
Range	Formula
B1:B10	B1	=COUNTIF(A$1:A1,A1)

 

[hanahass]

Hi Peter! Thank you for your reply!

If I use countif, it'll be

A 3
A 3
A 3
B 2
B 2

instead of

A 1
A 2
A 3
B 1
B 2

 

[Peter_SSs]

If I use countif, it'll be

A 3
A 3
A 3
B 2
B 2

No it wont, you can see it working in my mini-sheet.
Try it. Make sure that you use the formula I gave (assuming the data is in columns A:B as shown in my sheet), not the one you think I gave.

 

[hanahass]

Oh yes! Sorry! I didn't notice it was a mini-sheet. I got it now! and it's perfect!

Thank you so much Peter! I appreciate you! ?‍

 

[Peter_SSs]

You're welcome. Glad you got it sorted.