Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting no results from Advanced Filtering in Excel 2007
I'm attempting to use the advanced filtering in Excel 2007 but the filtered
list is identical to the unfiltered list though I have tried various critieria. I followed the Help guide meticulously, but get no apparent results. What am I missing? Is there something not mentioned in the Help file? Do the cells have to have a particular format? Additional info: Auto filtering works fine. List range and criteria ranges look right. There is a blank row between them. I input criteria using the ="=report" format. When I try to filter in place or designate a location on the same worksheet I get the full table repeated. When I try to paste to another worksheet I get the error message "You can only copy filtered data to the active sheet". Help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ADVANCED FILTERING IN EXCEL 2003 | Excel Discussion (Misc queries) | |||
advanced filtering | Excel Worksheet Functions | |||
Advanced filtering in Excel to find records ending in xxx? | Excel Discussion (Misc queries) | |||
display count/results of filtering Excel in status bar | Excel Discussion (Misc queries) | |||
Advanced Filtering | Excel Worksheet Functions |