Advanced Filter Criteria

vikkis

New Member
Joined
Aug 22, 2002
Messages
3
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!
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
See the Excel Help topic for "Types of comparison criteria".
Book1
ABCD
1FruitFruit
2Apples<>*p*
3Bananas
4Grapes
5Oranges
6
Sheet2

This message was edited by Mark W. on 2002-08-23 11:15
 
Upvote 0
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
ABCDE
1FruitFruit
2Apples<>*p*FALSE
3Bananas
4GrapesFruitFruit
5OrangesBananasBananas
6OrangesOranges
Sheet5
</SPAN>

Regards!

Yogi
 
Upvote 0

Forum statistics

Threads
1,218,746
Messages
6,144,263
Members
450,533
Latest member
xoxo1998

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
Back
Top