Let A:D house the records from A4 on, with headers in A4:D4.

Create the criteria range: F2:F3 with

F2 housing the text value XLoc
F3:

=ISNA(MATCH(C5,ClosedLocations,0))

Then run Advanced Filter on the data area.

Dawg House Inc wrote:
I have a 450 record listing that has five columns in it, of which, column C
is "Location". I also have a named range in Column J called
"ClosedLocations". I want to filter my 450-record listing to exclude any
record that has a location that is found in the "ClosedLocations" named
range.

Any suggestions?

Thanks in advance.
House