Advanced Filters criteria issues

Minx_Minxy

New Member
Joined
Jul 13, 2015
Messages
37
Office Version
  1. 365
Platform
  1. Windows
Hi guys, hope you doing well?:biggrin:

I need help with the following data using an advanced filter. The spreadsheet is really heavy with data already so I'd rather avoid using formula if it's possible.... here is the example:



[TABLE="width: 440"]
<colgroup><col span="3"><col><col></colgroup><tbody>[TR]
[TD]Created by [/TD]
[TD]DCI[/TD]
[TD] ACK[/TD]
[TD]Doc. Date [/TD]
[TD]Short Text [/TD]
[/TR]
[TR]
[TD]BR006364 [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]11/06/15[/TD]
[TD]BLIND,PADDLE,316, 2 150#,1/16 THK X4-8[/TD]
[/TR]
[TR]
[TD]BRBC0612 [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]11/04/15[/TD]
[TD]253807, 3 Step Lock-N-Stock Folding Ladd[/TD]
[/TR]
[TR]
[TD]BRS0183 [/TD]
[TD] [/TD]
[TD]03582226 [/TD]
[TD]11/02/15[/TD]
[TD]LABELS,ADDRESS 1 X 2.62 P/N 5960 [/TD]
[/TR]
[TR]
[TD]BRS0183 [/TD]
[TD] [/TD]
[TD]03578439 [/TD]
[TD]11/01/15[/TD]
[TD]BIN MONITOR,ROTARY PADDLE CAT.#1-01[/TD]
[/TR]
[TR]
[TD]BRBC0610 [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]09/14/15[/TD]
[TD]Add to PO# 4502574014: CAt.# EM-1698A-[/TD]
[/TR]
[TR]
[TD]BRBC0610 [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]08/20/15[/TD]
[TD]4502556762 Add line to PO - 7900-1491 [/TD]
[/TR]
[TR]
[TD]BRS0179 [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]03/04/15[/TD]
[TD]Add more $$ to PO 4502430589 [/TD]
[/TR]
[TR]
[TD]BRS0179 [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]12/31/14[/TD]
[TD]ADD TO PO 4502381212 [/TD]
[/TR]
[TR]
[TD]BRS0179 [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]12/18/14[/TD]
[TD]Add to Invoice 31655 Southeast Pump Spe[/TD]
[/TR]
[TR]
[TD]BR006364 [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]12/17/14[/TD]
[TD]CBT, 2015 Blanket PO. Add On [/TD]
[/TR]
</tbody>[/TABLE]




Ok, So I need the advanced filter to show me only "Short text" that is not equal to "Add to", "Add on", "Add more", "Add line" etc, on the example above with the advanced filter on I'd be shown only the first 4 rows, because the text does not say is adding something a value. At the moment only this "<>*add to*" is working, the rest is not hidden and if I just use "<>*add*" anything that says ADDress, lADDer or pADDle..disappears too.

I hope I was clear enough. Thank you guys!

All the best, Minxy ;)
 
Try adding a space to the end of add:

"<>*add *"
 
Upvote 0
In what way does it not work?
 
Upvote 0

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