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