I have a table like this in an Excel worksheet:
Mary Bremen Paul Berlin Anita Hamburg Klaus Berlin Peter Berlin Conny Bremen
and I want the number of the city names counted and output in HTML:
Berlin 3 Bremen 2 Hamburg 1
preferably sorted as for the cities with the highest numbers. How do I do this?