Is it possible to find cells using multiple values in excel?
Example:
We have:
1 LiamOlivia
2 OliviaEmma
3 LiamCharlotte
4 ElijahCharlotte
So here I want excel to find cells containing ?Olivia or Liam?. the result should be 1, 2, and 3.
The idea is to find multiple values, not just one.
Just imagine if I have 1000 cells and want to find cells containing one from 50 keywords (values). is it possible?
image_2022-10-14_014503420.png
Bookmarks