Text corerrelation, grouping text, textmining?

[Doman]

A question for the excel-guru? I know that it is a pretty general question, still.

I got data where each datarow concists of a single comment.

Comment
text
text
text
.
.
.

Now I want to group these comments together by checking simularities between the comments. Most oftly each comment includes one or several keywords that are included in some other comment.

How to do this?

The comments are between one and 15 words, often just one to five words.

[robert111]

I did a similar thing sometime ago. I needed to check around 100 words of test in each cell for 20 keywords, so i put the keywords in cells B2 - B21 and then wrote a formula that checked for each keyword (located at top of that column), returning a 1 when a match was found.

col1............................bob.......................tom
text text bob text............1.........................0
text tom text...................0........................1
tom text bob...................1........................1

it is a simple use of the search function