Glasgowsmile
Active Member
- Joined
- Apr 14, 2018
- Messages
- 280
- Office Version
- 365
- Platform
- Windows
I have data like below and I'm trying to use a filter formula to remove certain entries based on their email address:
I'm adding the emails I want to filter out into row E but the formula below isn't removing them from the original data set. What am I missing?
Formula:
Sample:
I'm adding the emails I want to filter out into row E but the formula below isn't removing them from the original data set. What am I missing?
Formula:
Excel Formula:
=FILTER(A:D, D:D<>E:E)
Sample:
First Name | Last Name | Role |