Need to Edit Word Frequency Macro

[newbieexceldude]

I have a macro that I found on the web. It takes all of the text strings in Column A and computes the most frequent 1, 2, & 3 word phrases.

I'd like to edit this macro to include phrases up to 6 words long. FYI... the number of rows in Column A might exceed 50,000.

Thanks guys/gals

-Dee

[shg]

This macro lists 1-word phrases in cols B/C, 2-word phrases in cols D/E, and 3-word phrases in cols F/G. Do you see a pattern that you might extend?

Please Login or Register  to view this content.

[newbieexceldude]

Thanks for responding SHG, but I'm not sure what you are asking...

I'm guessing that the macro would just go in sequential order in terms of columns (G,H,I, J...)

[shg]

I'll just be stubborn here and ask you to open your brain.

What line of code might you enter after these three to list 4-word phrases in col H?

Please Login or Register  to view this content.

[newbieexceldude]

Dude, I just realized how dumb I am!

Thanks for being stubborn. LOL

Slight issue though.... The buttons do not shift down, so the new data is copied on-top of them. Also, the Clear function only works for the original columns.

Thanks

[globalee]

Bomm, thanks for that, i did figure it out but i forgot to increase the phrase density number, many thanks SHG for the pointer, I actually have purchased the tool from the guy whoupped this sheet what is pretty good, but sorting out the density of strings of phrases from a big list is quicker in excel.