Advanced Filter

  • Thread starter Thread starter gareth
  • Start date Start date
G

gareth

I asked the following question yestrday and received the
following answer which works fine, BUT the question has
changed slightly today:

Q: I have a sheet of data which I need to filter. The
sheet contains several 100 rows of data, the data is split
into 3 categories and column B has either 1, 2 or 3 in it
depending on which category it is in. I want to filter the
sheet to show ALL category 1 data and any category 2 or 3
data which have an entry in column O.
A: =OR(B2=1,AND(OR(B2=2,B2=3),LEN(O2)>0))

Todays question includes another criteria:

I want to filter the sheet to show ALL category 1 data.
All category 2 or 3 data which have an entry in column O,
and no entry in column L.

Gareth
 
A slight change to the original formula:

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