| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Way to display filtered results from more than one autofilter per
I have several tables in the same tab. I would like to be able to apply
independent autofilters to each table and display filtered results for several tables at once. I tried to search online but didn't find any tips on how to do this. Is this possible in Excel 2003? Thanks in advance! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Way to display filtered results from more than one autofilter per
No, you can only have one set of autofilters active in one sheet at a
time. An alternative is to copy your tables into different worksheets, then you can set up filters on each table independently. Hope this helps. Pete |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can I use 2 formulas in 1 cell and display both results | New Users to Excel | |||
| How do you globally display "All" in an Autofilter? | Excel Worksheet Functions | |||
| How to display results to certain number of significant figures | Excel Discussion (Misc queries) | |||
| how do I display filtered records found | Excel Discussion (Misc queries) | |||
| how to display the count of lines found by autofilter? | Excel Discussion (Misc queries) | |||
Linear Mode
