I have a worksheet with about 3,500 rows.

There's a column with various U.S. cities -- some multiple instances, some single

I'm aware of the Countif function, but is there a way to count the number of instances of all of the cities without having to input each city name or sorting then manually counting?

I'd like to generate a table like this:
Abilene: 3
Ambly: 1
Atlanta: 45
Austin: 1

etc.

Any help is appreciated (I'm still a newbie)

thanks