Trying to find the most common word in a very large list

[Flying_Dutchman]

So I have a worksheet with 100+ entries, each of which have from 20-1000 characters, usually <100 words. My goal is to get a list of most common words in these entries and how commonly they are used.

so far my code looks like this:

Please Login or Register  to view this content.

it works okay for a few entries but any more than 8 entries and it breaks. It gives me "Run-time error 1004: application-defined or object-defined error". Any help would be much appreciated.

[rkey]

This should help you along the way:

[jindon]

try

Please Login or Register  to view this content.

[Flying_Dutchman]

rkey, there are more than one word in each cell, there are full sentences and such in each cell.

[Flying_Dutchman]

Jindon, that works great for the b2 to b9 region, once I take out the clear contents line but it still gives me the same error when i try to expand to include b10 or more.

[jindon]

Jindon, that works great for the b2 to b9 region, once I take out the clear contents line but it still gives me the same error when i try to expand to include b10 or more.

I can not replicate the error.

Can you upload the file with the dummy data?

[Flying_Dutchman]

Sure, though be warned this is in Dutch, though that shouldn't have much effect on the program.

[Flying_Dutchman]

there's something about cell b10 that throws off both of our programs. If I remove cell b10 it works fine.

[jindon]

The problem is


==========

Excel recognize it as equal sign.

try

Please Login or Register  to view this content.

[Flying_Dutchman]

Hey, that's awesome, it works really well and even expands to a larger sample until it encounters this cell:

"#001 - Vraag klant: na het ontkalkingsprocedure blijft het lampje branden. - Oplossing/gegeven advies: er staat in fout in de dfu omtrent het ontkalken. - Extra informatie: ik stuur klant per email link toe van de juiste ontkalkingsprocedure. PHILIPS Geachte heer Schönberger, U zou kunnen proberen om het apparaat te ontkalken, zoals op de link te vinden is: https://www.p4c.philips.com/cgi-bin/...1887&faqview=1 Philips staat voor Sense and Simplicity, ik hoop dat mijn antwoord u een oplossing heeft geboden. Mocht u verder nog vragen of opmerkingen hebben, aarzel dan niet om contact met ons op te nemen onde...(more)"

any ideas?

[jindon]

I don't get any error...

[Flying_Dutchman]

yeah, because that cell comes from another sample, which works great except for that one cell.

[jindon]

OK

I pasted it in B2

[Flying_Dutchman]

hmmm, weird because it was giving me an error before. Well thanks for all the help.

[jindon]

OK,

If you find any bugs, just post back.