filter out several items in a table using text filters

howard

Well-known Member
Joined
Jun 26, 2006
Messages
5,555
I have a data table and would like to filter out all items starting with an X, Y, Z


I have tried using Text filters does not contain, but it only allows 2 criteria


It would be appreciated if someone could kindly assist me
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Marcelo Branco

MrExcel MVP
Joined
Aug 23, 2010
Messages
16,371
You can create a helper column with a formula and use it to filter the data.
Or
Advanced filter

M.
 

Watch MrExcel Video

Forum statistics

Threads
1,102,369
Messages
5,486,449
Members
407,547
Latest member
Sankarasrinivas

This Week's Hot Topics

Top