Autofiltering for more than 2 items at once

[SlinkRN]

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?

 

[Mark W.]

Use an Advanced AutoFilter with a Criteria range like D1:D6 shown below...

Book1
	A	B	C	D	E	F	G	H	I
1	Field1			Field1
2	q			b
3	z			d
4	l			a
5	c			f
6	a			e
7	g
8	x
9	u
10	t
11	i
12	j
13	f
14
Sheet1

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

 

[PaddyD]

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]

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.]

SlinkRN, a very useful Help topic on the subject of Criteria construction is "Examples of advanced filter criteria".