Advance Filter Question?

  • Thread starter Thread starter Michael168
  • Start date Start date
M

Michael168

I set up a table with 3 columns by 1000 rows.
Col-1 data is from 000,001,002 ...until 999.

e.g. of Table to use for question.

Col-1 Col-2 Col-3
000 0 E
111 3 O
222 6 E
333 9 O
444 12 E
555 15 O
666 18 E
777 21 O
888 24 E
999 27 O

My question is how do I use the advance filter to filter out the tabl
with Col-2 value>=14 or Col-3 value =E?

After filtering , the table will be left as below.

Col-1 Col-2 Col-3
000 0 E
222 6 E
444 12 E
555 15 O
666 18 E
777 21 O
888 24 E
999 27 O

Please give advice how to set up the advance filter.
Thanks for the help
 
In the criteria area, leave the heading cell blank, and enter the
following formula in the cell below:

=OR(B2>=14,C2="E")

When you apply the Advanced Filter, include the blank cell and the cell
with the formula when selecting the criteria range.
 
Back
Top