Comparing strings in cells

[elippe24]

I am trying to compare columns based on how similar the strings in each cell are. For example, I want to take two strings "I write bad code" "I want to write better code" and combine all of the words into a single list:
I
want
write
bad
code
to
better

and determine that they are 42% similar since "I" "write" and "code" appear in both strings.

Any suggestions how to do this?

 

[SkipVought]

hi,

use the Split function to break the strings into words.

write the words to individual cells in a column

use the Data > Remove Duplicates feature to get unique values.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]