Dynamic count

[hegdep]

Suppose I have a column with recurring entries and I want to dynamically count the number of times the entry is present, what is the best way to do it?
For example, if I have John in A2, A5 and A7, B2,B5 and B7 should read 1,2 and 3 respectively.

[AliGW]

Do you only want to count when they appear together on the same row like this:

Excel 2016 (Windows) 32 bit

	A	B	C
1
2	John	John	1
3
4
5	John	John	2
6
7	John	John	3

Sheet: Sheet1

Or something else?

[Olly]

	A	B
1	Name	Count
2	John	=COUNTIF($A$2:$A2,$A2)
3	Andy	=COUNTIF($A$2:$A3,$A3)
4	Bill	=COUNTIF($A$2:$A4,$A4)
5	John	=COUNTIF($A$2:$A5,$A5)
6	Charlie	=COUNTIF($A$2:$A6,$A6)
7	John	=COUNTIF($A$2:$A7,$A7)

Which gives:

	A	B
1	Name	Count
2	John	1
3	Andy	1
4	Bill	1
5	John	2
6	Charlie	1
7	John	3

[JohnTopley]

Try

Assuming data starts in A2 and column A is list of names


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

This will increment count for a given name each time it is matched.

[AliGW]

Try this:

Excel 2016 (Windows) 32 bit

	A	B	C
1
2	John	John	1
3
4
5	John	John	2
6
7	John	John	3

Sheet: Sheet1

Excel 2016 (Windows) 32 bit

	C
1	=IF(A1<>B1,"",IF(COUNTIFS(A$1:A1,A1,B$1:B1,B1)=0,"",COUNTIFS(A$1:A1,A1,B$1:B1,B1)))

Sheet: Sheet1

[hegdep]

Thank you for your responses! All of them work fine.
I figured out my folly. I'm using my excel in English on a German PC.
Needed to use the semi colon instead of the comma in the formulas!