I have a number of locations listed in Column A. These are duplicated a
number of times. These are also variable (from a list of approx 60
possible locations)

How can I add the instances of the unique locations listed

For example, Column in could contain the following: London; Bristol;
London (again); Bath; Manchester; Bristol; Liverpool etc

I want to return (based on the above)

London =2
Bristol = 1
Bath = 1
etc
etc

I don't want to use the formula if=London etc etc as I have a list of
over 60 locations

Thanks