How To Delete/Filter all the rows that contain text from another column

enter image description here

Hello,

What Im trying to do is filter the First Name and Last Name columns by looking up all the values in E column and remove/filter.

So for example, first name in E column is Robert, what I would like is to be able to remove everybody named Robert from column A and B (I would like to remove the entire row, meaning both A and B column if the name is matching E column). And also for every other name in the E column

Really appreciate the help!

>Solution :

try:

=FILTER(A2:B; NOT(COUNTIF(E2:E; A2:A)))

enter image description here

Leave a Reply