I have two columns of data, one which contains a large number of values (column a), while the other contains a smaller amount of values(column e). I was wondering if anyone knew how to search for and highlight the values in column a, that are contained in column e (using column e a list of values which should be searched for) Here is what initial setup would look like:
and here is what the result would look like:
I've am able to search for and highlight single text values just find, I just cannot figure out how to search for a list of values all at once though. I actual list of items that I would be search for amounts to a couple hundred values, so manually search for individual strings of text would take forever. Any help is much appreciated, thanks!