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

Invert Filter - get the inverse of last filtering result

Invert Filter allows you to get the inverse of your last filter result. Suppose you have a list of 'Horses', and you just filtered for the horses between age 3 and 5. The inverse of the filtering result is simply the horses that are younger than 3 or older than 5.

DigDB allows you to invert filter with just one click. You can invert any filter result:

  1. Invert Excel AutoFilter and Advanced Filter
  2. Invert DigDB Filtering and Table Match
  3. Invert last Invert

Invert Excel's AutoFilter or Advanced Filter

  1. Click a single cell in a filtered area, invoke 'DigDB->Invert Filter'

    Invert Filter - Inverse
    Practice file - filter-invert-demo.xls (16k)

    Above screen shot has an AutoFilter of 'Age=5'. Excel's filters suppress the unmatched rows. Inverse of the filter result is shown as:

    Invert Filter - Inverse

  2. The suppressed rows are now shown. The shown rows in the last filter result are now hidden beneath the '+' sign. If you need to extract the invert result, invoke 'DigDB->Extract Result->Copy Visible Rows to New Sheet'

    Invert Filter - Inverse

Invert DigDB Filtering and Table Match

  1. After you are done with DigDB Filtering, or Table Match, click a single cell in the filter result area, invoke 'DigDB->Invert Filter'

    Invert Filter - Inverse

    Above screen shot has a DigDB filter of 'Age=5'. The unmatched rows are hidden beneath the '+'. Inverse of the filter result is shown as:

    Invert Filter - Inverse

    The invert simply switches the shown and hidden. If you need to extract the invert result, invoke 'DigDB->Extract Result->Copy Visible Rows to New Sheet'

Invert last invert

To clear all filtering and return to the original list, click 'DigDB->Clear Filter'. It clears not the DigDB filter result,but also Excel's AutoFilter and Advanced Filter.

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.