MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.

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.

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 ?

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

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

cool !