Identify Common Words (and combination of)

[ItsMeH]

Hi,

I've found this piece of VBA code on the forum (http://excel.bigresource.com/Track/excel-vFGPjVz4/) which lists the the number of times a word and combination of words is used from a column in Excel. I'd like to replicate it using a table in access containing the 'free text' and by creating a table for the output with a singlular list of words/combination of words.
e.g. tbl_FrequencyOutput
Col1= No of Words
Col 2= Word/Combination
Col 3= Count of combination in list.

Please Login or Register  to view this content.

I appreciate any assistance.

Regards,

H

[sathishkm]

This code is a good one and its very usefull