Countif to show result show only once per match

[Jocksteriom]

A countif in column 'Q' will find the number of times a value appears in column 'P' and display the value. However, it will show the same result on multiple rows depending on how many times it finds a match.
How can I display the result on one row only (last row would be better) and the others to be empty or null

Copy of Parish Walk Finishers (2023).xlsx
	P	Q	R
6	Data	actual	desired
7	smith	6	6
8	smith	6
9	smith	6
10	smith	6
11	smith	6
12	smith	6
13	Jones	3	3
14	Jones	3
15	Jones	3
ALL DATA

Cell Formulas
Range	Formula
Q7:Q15	Q7	=COUNTIF(P$7:P$15,P7)

 

[Special-K99]

There may be better ways, how about

=IF(COUNTIF(P$7:P7,P7)=1,COUNTIF(P$7:P$15,P7),"")

 

[Special-K99]

Or on last occurrence of value

=IF(COUNTIF(P$7:P7,P7)=COUNTIF(P$7:P15,P7),COUNTIF(P$7:P$15,P7),"")

 

[Cubist]

From another thread of mine, try:

=IF((XMATCH(P7:P15,P7:P15,0,1)+ROW()-1)=ROW(P7:P15),P7:P15,"")