Try using a formula like

=COUNTIF(A:A,C2)

where C2 contains the specific team that you want to count

" wrote:

Hi

What is the simplest way of counting the occurences of a name in a
column of names please?

Basically, I have a column of year on year League Champions names, and
want to create a Ranked list in another column based on how many times
the teams in the original column have won the title.

The new column would looks something like

Team F 8
Team A 7
Team D 4
etc
etc

Thanks
Neil