G Guest May 21, 2004 #1 Under Autofilter, the option CUSTOM can you increase number of criteria from 2 ?
D Debra Dalgleish May 21, 2004 #3 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
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
