I have many list like the one attached.

Over 200 of them.

Each list contains a list of companies people submitted.

I need to find the top 10 vote getting companies from each list.

sample.xls

Can anybody think of a way to help me do this?

Many times people will enter the same company, but spell it differently.

I was thinking about creating some kind of pivot table that counted unique words from the column while and adding the associated number.

I guess I first need to create a column that strips out the number in the parentheses first.

The file I attached as a sample is how they are turned into me.

Any help is appreciated.

Thank you!