Advanced Filters criteria issues

[Minx_Minxy]

Hi guys, hope you doing well?

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:

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

<colgroup><col span="3"><col><col></colgroup><tbody>
</tbody>

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

 

[RoryA]

Try adding a space to the end of add:

"<>*add *"

 

[Minx_Minxy]

Hi Rory,

Thank you but it does not work Do you have any other ideas?

 

[RoryA]

In what way does it not work?

 

[Minx_Minxy]

In what way does it not work?

When In use <>*add * it excludes the li9ne ending in "Ladd" as well

 

[RoryA]

Which version of Excel?