G
Guest
I'm using an Advanced Filter to filter my data but I can't figure out how to
set up my criteria range. I currently have this as my criteria range:
=AND(OR($E$2="",L4=$E$2),ISNUMBER(SEARCH($D$2,D4)))
Column L is one of the columns I want to filter my data by but I also want
to be able to filter other columns as well. Columns L thru P all have data
that I need to filter and I though just simply changing the above to this
would work:
=AND(OR($E$2="",L44=$E$2),ISNUMBER(SEARCH($D$2,D4)))
But it didn't. How do I re-write this formula to be able to lookup up the
data in multiple columns?
set up my criteria range. I currently have this as my criteria range:
=AND(OR($E$2="",L4=$E$2),ISNUMBER(SEARCH($D$2,D4)))
Column L is one of the columns I want to filter my data by but I also want
to be able to filter other columns as well. Columns L thru P all have data
that I need to filter and I though just simply changing the above to this
would work:
=AND(OR($E$2="",L44=$E$2),ISNUMBER(SEARCH($D$2,D4)))
But it didn't. How do I re-write this formula to be able to lookup up the
data in multiple columns?