Hi All,
I am trying to figure out a way to scan a list of text and return True or False if the text is repeated in another column. Below is an example of what I am looking to do. I tried if statements and also IsNumber(Seacrch() function and have looked all of the forum and the web with no help. As you can see below, I have text in column A that I want to see if it is repeated in the list in column C. In column B you see True next to Apple indicating that that text is in the list in column C. This is the same for Orange but since PWC is not in the list is returns False. Columns A and C I have formatted to Text and column B is formatted to General. I am using Excel 2016. I hope this makes sense to people! Anyway thanks a lot for any help you can give!
Brian
Capture.JPG
Bookmarks