Hi,
One way. Use a helper column alongside list B and enter the formula
=IF(ISERROR(MATCH(A1,list_a_range,FALSE)),"No Match","Match")
Copy this down and use a standard Excel Filter to either filter in place or extract to another range those rows which contain the word "Match".
Bookmarks