Counting Cell Values

Hello, I have an issue I am trying to resolve. I am looking for the top 10 places to live in the U.S. As you can imagine, there are hundreds of sites with their own list. So what I did was I went to 10 websites and put the top 10 places from those 10 websites and an excel spreadsheet (Attached). I need a formula that will in seperate cells 1. List each city, 2. count how many times a city is listed in the spreadsheet, and 3. tell me the average rank for that city. I've searched all over the internet and I cannot find a solution. Since I hardly ever do anything like this, I have no clue on where to start. Any help or guidance on how to accomplish this would be greatly appreciated.

Top_10_Live.xlsx46.6 KB