Thanks in advance for reading my request.

Ive got a worksheet that Lists champions in a Fantasy fighting league, id like a formula to count how many times a certain fighter has won a specific belt.
on a seperate worksheet Im counting the number of titles in a statistical breakdown.

All champions are listed in a single column I.E. Column A

A2 John Smith
A3 Jack Sullivan
A4 Mike Jones
A5 John Smith
A6 Tim Owens
A7 John Smith

So John Smith has 3 Title wins, I like a formula to show the number 3 in the corresponding cell.

Thanks again.