Forum Discussion
Compare 2 String Columns
Hi All, I have 2 columns [C1]&[C2] in my table, they are similar but not exact the same.
I am trying to compare these 2 columns, (If >1 word is match then "match", otherwise "Not match")
eg:
| C1 | C2 | Custom |
| there are 2 blue pen | blue pen | Match |
| 3 500kg box | mud | Not Match |
| 10 laptop bundled | bundled | Not Match |
May I know is there any way to achieve.
Appreciated!
1 Reply
ngct1112 , In case you need to compare by splitting words you need to use a list that you can use Text.ToList on one of the column and then have a solution like the one mentioned in this blog
https://www.excelguru.ca/forums/showthread.php?7724-Search-(Text-Contain)-multiple-values
