Custom Filter using more than two 'OR'
 

Hi,

I am trying to run a custom filter on a column, returning results if any of
three values are found in a cell.

For example, if "MO" or "TU" or "WE" are found.

However this function will not support more than one 'OR' in the code.

This is the code I tried to use:

Selection.AutoFilter Field:=1, Criteria1:="=ALL", Operator:=xlOr, _
Criteria2:="=" & myDay2, Operator:=x1or, Criteria3:="= MT"

Is this how this Autofilter is setup to work (only one 'OR') or is my code
wrong?

Any assistance would be greatly appreciated.

Thanks,
GLT.

Custom Filter using more than two 'OR'
 

Yes, it only supports two criteria.

You will either need to us an advanced filter or put in a dummy column that
has a formula that determines if the row should be visible or not and filter
on that column.

--
Regards,
Tom Ogilvy


"GLT" wrote in message
...
Hi,

I am trying to run a custom filter on a column, returning results if any
of
three values are found in a cell.

For example, if "MO" or "TU" or "WE" are found.

However this function will not support more than one 'OR' in the code.

This is the code I tried to use:

Selection.AutoFilter Field:=1, Criteria1:="=ALL", Operator:=xlOr, _
Criteria2:="=" & myDay2, Operator:=x1or, Criteria3:="= MT"

Is this how this Autofilter is setup to work (only one 'OR') or is my code
wrong?

Any assistance would be greatly appreciated.

Thanks,
GLT.

Custom Filter using more than two 'OR'
 

Also,

On this I have found the Database functions to be very useful:-
=DSUM =DSUMIF, etc.

somethinglikeant

Custom Filter using more than two 'OR'
 

The advanced filter is the filtering equivalent to the D functions (there is
no DSUMIF I am aware of).

--
Regards,
Tom Ogilvy


"somethinglikeant" wrote in message
oups.com...
Also,

On this I have found the Database functions to be very useful:-
=DSUM =DSUMIF, etc.

somethinglikeant

Custom Filter using more than two 'OR'
 

Apologies Tom

Custom Filter using more than two 'OR'
 

Hi Tom,

How do I set up an advanced filter in VBA?

I tried to do it via the help and I can't make any sense out of it ...

Chrees

"Tom Ogilvy" wrote:

Yes, it only supports two criteria.

You will either need to us an advanced filter or put in a dummy column that
has a formula that determines if the row should be visible or not and filter
on that column.

--
Regards,
Tom Ogilvy


"GLT" wrote in message
...
Hi,

I am trying to run a custom filter on a column, returning results if any
of
three values are found in a cell.

For example, if "MO" or "TU" or "WE" are found.

However this function will not support more than one 'OR' in the code.

This is the code I tried to use:

Selection.AutoFilter Field:=1, Criteria1:="=ALL", Operator:=xlOr, _
Criteria2:="=" & myDay2, Operator:=x1or, Criteria3:="= MT"

Is this how this Autofilter is setup to work (only one 'OR') or is my code
wrong?

Any assistance would be greatly appreciated.

Thanks,
GLT.