Filtering one sheet based on an other

Unsolved

Sorry for asking what may be simple thing but I just don't understand Sheets well :(.

If I have sheet one with column a with the following values:

Orange Pair Apple Coca cola

And in sheet two column a us:

Pair Apple

I want sheet three to have column a:

Orange Coca cola

In other words: sheet 3 = sheet 1 after subtracting (deleting) entries in sheet two .

Thanks to all!

SF

Posted Aug 19, 2024, 2:45 AM UTC

26
Loading comments…