Archive of Mr Excel Message Board

Back to General Excel archive index
Back to archive home

Advanced Filters

Posted by Dave on February 06, 2002 1:02 PM

I would like to filter a sheet 2 different ways.Is there a way of doing this without having to manually type in the criteria range each time I filter the sheet a different way.?
Filter 1 would = (Bill) (Bob) (brian)
Filter 2 would = (Kim) (Lisa) (Sara)

Thanks in advance for any help you can offer.
Dave

Re: Advanced Filters

Posted by Mark W. on February 06, 2002 1:48 PM

Use the View | Custom Views... menu command to
save your different Advanced Filtered lists.

Re: Advanced Filters

Posted by Chris D on February 06, 2002 1:48 PM

VBA aside,

if you want to filter on any of these 6 names :

add a column
enter - =if(or(cell with name={Bill;Bob;brian;Kim;Lisa;Sara}),"Yes","no")
copy down

record a macro that filters on this new column
criteria is : equals "Yes"

if you mean two seperate filters of those 3 names, then same thing but record 2 different macros, one for the "b"s and one for the "females"

is that what you had in mind ?
Chris

Re: Advanced Filters

Posted by Chris D on February 06, 2002 1:50 PM

Ooooo, nice one Mark, I didn't know about that

cool !
Chris

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.