Advanced Filter criteria

  • Thread starter Thread starter Gareth
  • Start date Start date
G

Gareth

A few weeks ago I asked a question and got the following as an answer:

=OR(B2=1,AND(OR(B2=2,B2=3),I2>=36708,LEN(L2)=0,LEN(O2)>0))

This is what I believe it filters for:
all rows which have 1 in column B
all rows which have either 2 or 3 in column B and which meet the following
criteria:
column I (date column) is >= 01/07/2000, column L is empty and
column O has something in it

I now find myself needing to change it slightly, I have tried but cannot
seem to get it quite right. What I want the formula to filter now is:
all rows which have 1 in column B
all rows which have either 2 or 3 in column B and which meet the following
criteria:
column O has something in it
if column O is empty then filter for column I (date column) is >=
01/07/2000, column L is empty

Thanks in advance.

Gareth
 
The following formula should work:

=OR(B2=1,AND(OR(B2=2,B2=3),OR(O2<>"",AND(L2="",I2>=DATE(2000,7,1)))))
 
Back
Top