Minx_Minxy
New Member
- Joined
- Jul 13, 2015
- Messages
- 37
- Office Version
- 365
- Platform
- Windows
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:
[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

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
