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)))
