Oct 23 2019 04:59 AM
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 years back when he was a 5 year old.
Column 2: Mark's son John is 15 years old, I had met him few years back when he was 5 a year old, today he has grown up into an all rounder.
I have such details for 1000 of rows; Need help in the following
1. How to match if C1 is sub set of C2 using string match or vice versa
2. how to check % of matching of C1 on C2.
3. Is it possible if there is/are unrelated words in between of a sentence and still can be matched?
Your help is much appreciated.
Thanks
Oct 23 2019 05:20 AM
Oct 23 2019 06:25 AM
Oct 23 2019 04:09 PM
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
Oct 10 2020 01:54 PM
@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