I have a list of towns, and there are duplicates in it. Each town represents a sale.

Example:

A1
Melbourne
St. Kilda
Warburton
Euroa
Melbourne
St.Kilda

So I have just been using the find all tool to find all entries of the specific town and copying them into B1, counting how many duplicates there are and recording them in another sheet. I then find all the same entry and delete it from my list.

Is there a way to summarise this data in another sheet.

Example.

A1 B1
Melbourne 2
St. Kilda 2
Euroa 1
Warburton 1

Would love some help!