I am looking to match text in column B to all of the text in column A to see if any of the words are repeated, I would also like it to match similar words for example if Apples is is column B and Apple is in column A. If they are repeated I would like to easily see where the repeated word is either by highlighting each repeated word in a different color or reporting a value in Column C in the adjacent row. Thanks in advance!
Bookmarks