filter according to a list of filters

[userman]

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]

anyone?????????

[Colin Legg]

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.