advanced filter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I'm trying to do an advanced filter with many criterias
e.g.
1 "begins with A"
2 "does not end with B"
3 "does not contains c"

The problem is that I can only one of each at a time
e.g. I wrote:
"Name of column"
="=A*"


So the advanced filter shows me all data beginning with A in this column,
I've tried writting all 3 criterias in different cells like:

"Name of column"
="=A*"
="<>*b"
="<>*c*"

but It doesn't work.
I want to know how I could write an "and" so that I can use all 3 criterias
at the same time with excel's advanced filter or, if it's more optimal, how
to write a Vba code that will give a similar result?

Thank you
 
giving credit to Walt the answer to my questions is

"Name of column" "Name of column" "Name of column"
="=A*" ="<>*b" ="<>*c*"


We need to think of columns as
"and" and rows as "or" criteria.

Thank you everybody!!
 
Back
Top