Help - Count Top 10 Winners

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!

Thank you NBVC and K m.

I tried over and over again to use your four equations.

But I kept getting #name? errors.

I looked at them closely but couldn't figure out what could be wrong.

I am afraid I am going to have to tally up the winners the old fashion way.

Thank you again,

Tyler

Well, I have two problems.

I have spliced together a .xlsb file the best I could.

The two problems I have are:

One: Column 5, I can't get cells below row 24 to fill in properly. When I copy the formula above it, it just repeats with "Zios"

This column is supposed to be a list of unique words from column 3, but only listing the words once.

Two: Column 6, I want to find the occurrence of the word from RC[-1] not the exact phrase from RC[-1], then add together the value from column 4 when that word from column 5 appears in column 3.

Then as a bonus, I am hoping to create a new sheet that list the top 30 values from column 6 with it's corresponding unique word from column 5, in descending order.

Wow, did that make sense?

Here is my file so far, if anybody wants to download it and fix it for me, that would be wonderful!

Unique-distinct-words1 Tyler.xlsb.zip

(I had to .zip compress it first because the site wouldn't let me upload the .xlsb file.)

Thank you NBVC very much.

I barely know what I am doing and you were a big help.

I will try the programming area.

Yea, I figured out problem one.

Now trying to figure out problem two.

I can't believe it.

All figured out and I could not of done it without everybody's help.

It was a lot of fun too figuring everything out.