Hello geniuses,
I am a first time poster here but I've been spending some time with this issue and I'm not sure if it's possible. I've got 2 columns filled with text and what I'd like to do is compare A1 to B1:B5178 then A2 to B1:B5178 and so on down column A and flag those with a > 50% match by word (or maybe character if word isn't possible).
I currently have a formula to flag exact matches, but I have way more "close" matches than exact.
Any ideas?
Thanks so much.
Bookmarks