Autofilter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Under Autofilter, the option CUSTOM can you increase number of criteria from 2 ?
 
If you need more than three criteria, you can use an Advanced Filter.
There are instructions in Excel's Help files, and on my web site:

http://www.contextures.com/xladvfilter01.html

Or, you may be able to add a column to your table, and filter on that.
For example, to filter for three provinces, enter the formula:
=OR(A2="Ontario",A2="Quebec",A2="Manitoba")
Copy the formula down to the last row, and filter that column for TRUE
 
You must log in or register to reply here.

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

Multiple criteria in autofilter 1
Autofilter not grabbing last row 1
VBA Autofilter Arrays 5
How can run a macro ( call a macro) on selection of any filtercriteria? 7
Is there a better way to do this? 6
custom autofilter 3
How to filter only the numbers I need 3
Autofilter on rows instead of columns 6

Back
Top