Compare customer institutes names between 2 columns

Question

Good afternoon,I have 2 columns with in both some text (they contain a list with customer names which can be a single word but also longer institute name as in "the university of ......).I want to compare them per row and highlight the ones that are either the same or significantly different - whatever is easiest.Note: I want a "rough" comparison - so if the names "look similar" it is okay for this purpose. I am interested in identifying the cells that show a really different content.I know I have seen that somewhere but I can't find it anymore. Thank you!Regards,Ronald

wyn hopkins · Answer

Ronald_Daas&nbsp;
&nbsp;
I've never tried this&nbsp; Fuzzy Lookup add-in and am not sure it even works
https://www.microsoft.com/en-au/download/details.aspx?id=15011
&nbsp;
But I don't know of any built in functionality that would help you

ronald_daas · Answer

Thank you Imk - I will give that a tryRegards,Ronald

lmk001 · Answer

Ronald_DaasYou could try:1. =COUNTIF(I1:I1,J1)=0In my example, I1 is the first column and J1 is the second column.&nbsp;2.&nbsp; Highlight the first column that you are comparing to the second column.&nbsp; So you would Select the Entire first column as your range.&nbsp;&nbsp;Hope this helps.&nbsp;&nbsp;&nbsp;

Forum Discussion

Compare customer institutes names between 2 columns

3 Replies