To create exclusion criteria, use the following formula
where firstcell is the first cell in the field of your database that you want to filter and excludelist is the list of entries that you want to exclude.
When you filter records in an Excel database, you usually specifycriteria that you want the records to match. However, when you use the ISNA and MATCH worksheet functions, you can create an advanced criteria that filters all records that do not match the criteria.
For more information about advanced filters, click Microsoft Excel Help on the Help menu, type filter a list by using advanced criteria in the Office Assistant or the Answer Wizard, and then click Search to view the topic.