MrExcel Publishing
Your One Stop for Excel Tips & Solutions

auto filter?

Posted by Paul on October 10, 2001 5:41 PM

I have a worksheet set up with Qt. As the column B name Final, 1st Qt., 2nd Qt., 3rd Qt., 4th Qt. In column B rows 2:6, this goes on down the sheet in the same order, I can use auto filter to filter any one of these but when I pick custom and Qt. Equals Final and equals 1st Qt. It want show anything, it goes down to row 102 but nothing is on the page. How can I display only the rows with final and 1st Qt. in them? I am using Excel ’97. Thanks for your help

Posted by Travis Harr on October 10, 2001 7:33 PM

Use an "Or" statement NOT "And"