Does the cell contain any of the items in the list


February 10th, 2018 by admin admin

One of my friends got an excel list and he wishes to find out in this list whether any of words he has in a second list can be found in the first list. He came out with a formula which is extremely long and find that it is impossible to use the formulas if his second list expands to 200 items. So he shouted for help to come out with a shorter formula. I didn’t come out with one for him but googled the right key words to find somebody has done it. It is in this page https://exceljet.net/formula/cell-contains-one-of-many-things

 

Leave a Reply

You must be logged in to post a comment.

s2Member®