Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Filter not filtering
XL2003. I use often use Advanced Filter, but I have one file from a user that
will not play. When I put an advanced filter on it, it returns the entire table, not just the filtered bits. There are no blank cells in the table, I have copied it and pasted just the values, I've multiple-checked I'm setting up the AF correctly. I'm usually filtering in place, but I've tried filtering it to another place and the entire table goes there. It works fine as a List and with Autofilter. Please can anyone suggest what setting I am missing to make it work with Advanced Filter? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Filter not filtering
Update: If I only have criteria in Row 2, and select just Row 1 (titles) plus
the Row-2 criteria range it works. I was selecting all Rows 1-3. This only works if I have criteria in both Rows 2 and 3. If I have 'fixed' this I no longer need help with the problem, but I am still puzzled. "Jonathan589" wrote: XL2003. I use often use Advanced Filter, but I have one file from a user that will not play. When I put an advanced filter on it, it returns the entire table, not just the filtered bits. There are no blank cells in the table, I have copied it and pasted just the values, I've multiple-checked I'm setting up the AF correctly. I'm usually filtering in place, but I've tried filtering it to another place and the entire table goes there. It works fine as a List and with Autofilter. Please can anyone suggest what setting I am missing to make it work with Advanced Filter? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
advanced filtering | Excel Discussion (Misc queries) | |||
Advanced Filtering | Excel Discussion (Misc queries) | |||
advanced filtering | Excel Worksheet Functions | |||
Advanced filtering | Excel Discussion (Misc queries) | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions |