Return Results That Do Not Match Filter

[Hastings]

I am usining the script below to filter out data from the Data Tab that match my items in the Criteria Tab and return them in the Dest Tab.
How would I change this script to return items that dont match my criteria?

 

[RoryA]

I wouldn't use that script as starting point as it's pretty specific to its original purpose. (also, you posted it as a picture for some reason, which means anyone wanting to use it would have to type it out from scratch!)
I'd use an advanced filter instead with a two cell criteria range - blank first cell and under that a formula like =COUNTIF(Criteria!$A:$A,Data!N2)=0

 

[Scott Huish]

You also have Excel 365, so you could probably use the newer FILTER function, but you would need to provide some more details, what range in both sheets?

 

[Hastings]

You also have Excel 365, so you could probably use the newer FILTER function, but you would need to provide some more details, what range in both sheets?

If I do the advanced filter I can return everything but sue.jones (see filter list at the bottom) but if I add more names to the list to omitt it doesnt work.

Source

FY

BillMonth

ActivityCode

CodeDescription

ServiceType

BeginDate

EndDate

Units

Rate

Charge

AccountNumber

AgencyName

Description

VIP

2024​

12​

CC10

Client Computing - Tier 1 ($550 max HW)

Rated

45261​

45291​

1​

60​

60​

HSMSAA00

Accounting

bob.smith@gmail.com Dell OptiPlex 5070 SFF Desktop 144W9Z2 Warren

VIP

2024​

12​

CC10

Client Computing - Tier 1 ($550 max HW)

Rated

45261​

45291​

1​

60​

60​

HZZXAP00

Sales

Dell OptiPlex 5070 SFF Desktop 144W9Z2 sue.jones@gmail.com

VIP

2024​

12​

CC10

Client Computing - Tier 1 ($550 max HW)

Rated

45261​

45291​

1​

20​

60​

HSSXBA00

Purchasing

Dell OptiPlex 5070 SFF Desktop bill.black@gmail.com144W9Z2

VIP

2024​

12​

CC10

Client Computing - Tier 1 ($550 max HW)

Rated

45261​

45291​

1​

30​

60​

HSMSAA00

IT

bad.name@gmail.com Dell OptiPlex 5070 SFF Desktop 144W9Z2

VIP

2024​

12​

CC11

Client Computing - Tier 1 ($550 max HW)

Rated

45261​

45291​

1​

60​

60​

HSMSAA01

HR

scott.kline Dell OptiPlex 5070 SFF Desktop 144W9Z3

Description

<>*sue.jones*