Autofiltering for more than 2 items at once

SlinkRN

Well-known Member
Joined
Oct 29, 2002
Messages
701
I want to autofilter a list for about 5 conditions. For example, I want to show cells that have a "b" or a "d" or an "a" or a "f" or an "e" in them. The cells all have just one letter in them or are blank. Can I specify that many conditions to filter?
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Mark W.

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,654
Use an Advanced AutoFilter with a Criteria range like D1:D6 shown below...
Book1
ABCDEFGHI
1Field1Field1
2qb
3zd
4la
5cf
6ae
7g
8x
9u
10t
11i
12j
13f
14
Sheet1

This message was edited by Mark W. on 2002-10-30 15:18
 

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
This is one of the topics well treated in the help files - type in advanced filter & take a look at the "Filter a list by using advanced criteria" topic. post back if you can't get it to work.

paddy
 

SlinkRN

Well-known Member
Joined
Oct 29, 2002
Messages
701
Thanks Mark! I read the help menu over and over, but it wasn't until I saw your example that I got it to work. I wasn't typing in "field 1" and then I couldn't get it to accept my list. Thanks again!
 

Mark W.

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,654
SlinkRN, a very useful Help topic on the subject of Criteria construction is "Examples of advanced filter criteria".
 

Watch MrExcel Video

Forum statistics

Threads
1,122,553
Messages
5,596,807
Members
414,104
Latest member
imamalidadashzada

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top