List Summary - Really would appreciate some help.

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!

Thanks Rahul I just looked into the countif function, not knowing already as I'm a beginner.

So I can use countif to make calculating the number of times Melbourne appears in a list easier.

I still need further help as the list is 2400 cells down and many entries are one offs. It took me 6 hours to get through one the other night.

I need to summarise the list to look like the second example in my original post.

If you are trying to view them by the areas they are in you can do it in several ways. You can use a auto-filter (Data/Filter/Auto-Filter- to do this select the columns by highlighting them), this will then filter all the cells underneath it and turn it into a pull down list of all the towns. then when you select the town from the pull down list it will show all for that town only.

The other way is to highlight them all (using the town column first) and hitting the A - Z button to put them in greographical order.