Help please fixing a macro

I am using Mac Excel 2011.

My file is a .xlsb file.

Others in a different forum have helped me, but now I need programming help to fix a macro.

If anybody can help me, great.

Here is the other thread:
http://www.excelforum.com/excel-char...0-winners.html


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 very much!!!!

Tyler

I figured out one part. Yea!

Problem one done.

Now trying to solve problem two.