Sorting out values quickly

Hello, I'm wondering if there is a quick way to sort out a handful of values from a list of values.

If you see attached spreadsheet - on Data sheet, would like to sort out (to remove) from column B the list from the second sheet 'Sort to remove'.

I could do a vlookup in another column - just wondering if there is a sort/filter option.

Let me know,
Thank you.

The quickest way to do this manually is to:

Add another column to Data with the following formula:

Formula:

Please Login or Register  to view this content.

Remove Filter then reapply Filter to include the new column

Filter for TRUE and delete those rows.


This could also be done with VBA if this is a repetitive process.