DigDB      Excel Add-ins      Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes? (more ...)

Features | Testimonial | Download free 15-day trial | Purchase | FAQ | Contact

Filter Excel Table (List) - Multiple Criteria, Nested Conditions

Filter example: filter horses that are black, or roan in 'color', or have a star in 'body_mark'

  1. Click into any cell within your table area.
  2. Invoke 'DigDB->Complex Filter->Filter...'.

    Excel filter - advanced & complex filtering

  3. The table area will be automatically selected to include all the continuous data area around the current cell. The auto-selected range is the table to filter.

    Excel filter - advanced & complex filtering

  4. Set filter criteria:

    Excel filter - advanced & complex filtering

    Click 'Add Criteria' to add another criteria. Your criteria is now: black or roan in 'color', or have a star in 'body_mark'

    Excel filter - advanced & complex filtering

  5. Click 'OK' to filter, get result. Matched is shown, unmatched will be hidden beneath the '+' sign. You can click the '+' to expand and show the unmatched rows. You can also click the small '2' to expand, and click '1' to retract.

    Excel filter - advanced & complex filtering

  6. Expanded to show the unmatched rows.

    Excel filter - advanced & complex filtering

  7. Extract filter result. Make sure the unmatched are retracted, click 'DigDB->Complex Filter->Extract Result->Copy to New Sheet', the matched (visible) rows will be copied to a new sheet.

    Excel filter - advanced & complex filtering

    You can click 'DigDB->Clear Filter' to get rid of the filter and the '+', '1', '2' signs to go back the simple list.

  8. Result in a new sheet. The sheet will be automatically created.

    Excel filter - advanced & complex filtering

More complex filter criteria:

Need more?


Features | Testimonial | Download | Purchase | FAQ | Contact | Excel Resume Examples ( wehtwrjw )

Copyright © 1999-2007 All rights reserved

DigDB      Excel Add-ins      Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes?

Related keywords: Advanced excel tips, excel questions tools, Excel reporting applications, Excel add-ins add-in, Excel shareware, Excel plugin plug-ins plugins, Excel tricks question, Excel utility utilities, Excel add-on add-ons, Excel tip tips, Power excel technique, Excel manipluation, Excel guru, Excel trick, Excel toolkit, Excel app power user

Microsoft Office Marketplace logo
Microsoft and the Office logo are trademarks or registered trademarks of
Microsoft Corporation in the United States and/or other countries.