Archive of Mr Excel Message Board

Back to Data in Excel archive index
Back to archive home

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

Use an "Or" statement NOT "And"

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

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.