Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Advanced Filter Question
I want to use a named range, which is a single value as the "equal to" criteria in the advanced filter dialog box. I have a named range of a single cell I call "FlicNum". I have a list of 'flicnums' and actor numbers. With over 130 thousand DVDs in the main list, the actor list index is about 660 thousand records long. If I filter on "FlicNum" I should only see a list of actor numbers that tie to that FlicNum. That is the goal. Getting the filter to accept my "variable" is the obstacle. If I enter a 'flicnum' (DVD ID number) by hand, it filters on it just fine. How do I plug in a "variable", or named range into a filter dialog or specification? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question about Advanced Filter | Excel Discussion (Misc queries) | |||
Question with use of advanced filter to select empty cells | Excel Discussion (Misc queries) | |||
Advanced Filter Question | Excel Worksheet Functions | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
Advanced filter question | Excel Discussion (Misc queries) |