Thread: How Do I Do an Exclude Filter based on a Named Range?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dawg House Inc
 
Posts: n/a
Default How Do I Do an Exclude Filter based on a Named Range?
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
--
Dawg House Inc.
"We live in it, therefore, we know it!"
Reply With QuoteReply With Quote