advanced filter
 

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

advanced filter
 

see my response to your posting in the Worksheet Functions group

"raph_baril" wrote:

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

advanced filter
 

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!!


"raph_baril" wrote:

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