I want to use autofilter for more than 2 filter criteria, i.e.
equals 1 or 2 or 3 or 4 or 7....

Is there a function I can use in the right half of the 'custom autofilter'
window to allow this?

you can not set formulas on the filter criterias, but you may want to set an
additional column where you could set a multiple conditional function(IF,
AND, OR) and then filter using the new column.
If you post some data it maybe easier to come up with a more detailed answer.
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"BASFMark" wrote:

I want to use autofilter for more than 2 filter criteria, i.e.
equals 1 or 2 or 3 or 4 or 7....

Is there a function I can use in the right half of the 'custom autofilter'
window to allow this?