counting changing names in a column

[hissonrr]

Good day all,

Feel like this should be simple but cant figure it out.

Basically I have a column of names and need to count them as they descend if they are duplicates (see example below)

So I need a formula for column B that does the counting.

Any help would be appreciated

	A	B
1	John
2	John
3	Rob
4	Betty
5	Betty

So with the formula would look like this...

	A	B
1	John	1
2	John	2
3	Rob	1
4	Betty	1
5	Betty	2

 

[Fluff]

How about

=COUNTIFS(A$2:A2,A2)

 

[hissonrr]

How about

=COUNTIFS(A$2:A2,A2)

Works prefect

Thank you!

For myself would you mind explaining how that works?

 

[Fluff]

Initially it just looks at A2, then when dragged down one cell it looks at A2:A3 etc