filter according to a list of filters

userman · #1 06-01-2012, 08:13 AM

hello!

how can I filter all the rows that:

- the whole text of any cell of the row matches the text of a cell from a list
- the whole or part of the text of any cell of the row matches the text of a cell from a list
- the whole text of a cell of a specific column of the row matches the text of a cell from a list
- the whole or part of the text of any cell of a specific column of row matches the text of a cell from a list

how can I filter all the columns that:

- the whole text of any cell of the column matches the text of a cell from a list

- the whole or part of the text of any cell of the column matches the text of a cell from a list
- the whole text of any cell of a specific row of the column matches the text of a cell from a list
- the whole or part of the text of any cell of a specific row of the column matches the text of a cell from a list

thanks!

userman · #2 06-12-2012, 12:31 AM

anyone?????????

Colin Legg · #3 06-12-2012, 02:19 AM

You'll have to use the advanced filter. I haven't gone through step-by-step all of your criteria, but it should be able to do most of them without too much difficulty. Read the examples here to get started.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
filters	userman	Outlook	1	05-29-2012 01:50 PM
Filters in MS project	Antares	Project	3	12-04-2011 09:14 AM
Graphics Filters	judicial85	Office	0	10-15-2011 10:46 AM
Growing Filter List	rbdmg	Mail Merge	1	10-10-2011 02:56 AM
Microsoft Office XP/2003/2007/2010 Graphic Filters "Allow List" Explanation	Jazz43	Office	0	08-24-2011 10:47 AM