Multiple criteria in autofilter

  • Thread starter Thread starter BASFMark
  • Start date Start date
B

BASFMark

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Macro to use cells as a autofilter 0
custom autofilter 3
Is there a better way to do this? 6
VBA: How can I use a string variable as autofilter criteria? 4
Autofilter on rows instead of columns 6
Autofilter not allways working Excel 2003 1
How to make list of Items displayed in AutoFilter? Any Function? 8
Count the number of AutoFiltered records 6

Back
Top