Archive of Mr Excel Message Board
Back to Data in Excel archive index
Back to archive home
Excluding in an advanced FilterPosted by Melanie Swarner on October 22, 2001 5:51 AM
Aside from putting an AND condition in every statement of my criteria, how can I exclude certain rows, right off the top in Advanced Filter?
I have certain rows that I want to just get rid of because none of my criteria works on those rows because of an error in the system the data comes from.
I saw a post about this on this board, but I can't find it anywhere now.
Re: Excluding in an advanced FilterPosted by Robin on October 22, 2001 6:36 AM
Place an auto filter on all of your data and build a custom filter on the appropriate fields using the "does not equal" drop down.
Once the correct rows are displayed, you can copy and paste these on there own into a new worksheet.
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.