Advanced Filter Criteria

[vikkis]

I'm trying to set-up an advanced filter, and would like to use the "does not contain" logic that can be used in an autofilter in the criteria section... is this possible, and if so, what is the syntax?

Thanks for your help!

 

[Mark W.]

See the Excel Help topic for "Types of comparison criteria".

Book1
	A	B	C	D
1	Fruit		Fruit
2	Apples		<>*p*
3	Bananas
4	Grapes
5	Oranges
6
Sheet2

This message was edited by Mark W. on 2002-08-23 11:15

 

[vikkis]

Thanks!!!!

 

[Yogi Anand]

Hi vikkis:

Mark has already provided you a solution using the<>*p* criterion,

as a variation, you may also use the following computed criterion:

=iserror(find("p",A2,1))

see the worksheet simulation

Book1
	A	B	C	D	E
1	Fruit		Fruit
2	Apples		<>*p*		FALSE
3	Bananas
4	Grapes		Fruit		Fruit
5	Oranges		Bananas		Bananas
6			Oranges		Oranges
Sheet5

</SPAN>

Regards!

Yogi