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