#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default Custom Filter/Views

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Custom Filter/Views

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom Views Michael Gudyka Excel Discussion (Misc queries) 6 June 26th 08 06:54 PM
Custom Views Khardy3352 New Users to Excel 2 June 22nd 08 01:37 PM
custom views Mac Excel Worksheet Functions 1 October 5th 06 06:38 PM
Custom Views gailann Excel Discussion (Misc queries) 1 June 30th 06 04:26 PM
Custom Views Dana Excel Worksheet Functions 1 March 6th 06 09:52 PM


All times are GMT +1. The time now is 01:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"