Forum Discussion
Compare Sentence to sentence in two sets of data
Hi I have two sets of details regarding a same item/product. Need to know how can I compare them sentence to sentence or word to word. Eg: Column 1 : John is now 15 years old, i had met him few...
I suddenly realised you may be able to do part of this using Excel Power Query
(if you have Excel 2016 or later this demo file should work)
Have you used Power Query before?
It only compares the number of words that match list 1, and doesn't look at order
Wyn Hopkins Thank you for sharing "Sentence Comparer.xlsx" I found it very helpful. I noticed that when using it with my data of 1053 sentences it switches the order of comparisons leading to comparing sentences from different lines that usually results in 0 matches.
Do you have any suggestions?
Thank you
Aziz