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

This should help you along the way:

try

Please Login or Register  to view this content.

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

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.

Originally Posted by 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.

I can not replicate the error.

Can you upload the file with the dummy data?

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

The problem is


==========

Excel recognize it as equal sign.

try

Please Login or Register  to view this content.

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?

I don't get any error...

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

OK

I pasted it in B2

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

OK,

If you find any bugs, just post back.