| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Range matching multiple named Ranges | Excel Discussion (Misc queries) | |||
| Named Range Calculations | Excel Discussion (Misc queries) | |||
| advanced filter a range | Excel Worksheet Functions | |||
| Offset Function works in cell, not in named range | Excel Worksheet Functions | |||
| Identifying single column within named range | Excel Discussion (Misc queries) | |||
Threaded Mode
