Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi
Is there a way to use more than 2 criteria in a Custom Autofilter? I've set up some Custom views which display custom autofilter results but on certain veiws i want to display more than 2 sets of results. Is this possible? Thanks for any suggestions. Paul |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Not in xl2003 or previous.
But you may be able to use advanced filter and a criteria range. Or even add another column and use a formula that includes all the criteria you want. Then filter by that. " wrote: Hi Is there a way to use more than 2 criteria in a Custom Autofilter? I've set up some Custom views which display custom autofilter results but on certain veiws i want to display more than 2 sets of results. Is this possible? Thanks for any suggestions. Paul -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Custom Views | Excel Discussion (Misc queries) | |||
Custom Views | New Users to Excel | |||
custom views | Excel Worksheet Functions | |||
Custom Views | Excel Discussion (Misc queries) | |||
Custom Views | Excel Worksheet Functions |