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 Blank in Excel

Excel has a simple AutoFilter that allows you to filter the blanks and non-blanks. But in a nested situation, for example, filter the rows where 'Col1' = blank OR 'Col3' > 5, you will have to use Excel's Advanced Filter which requires the construction of an esoteric 'formula range'. DigDB allows you to nest blank filter conditions into complex criteria easily.

Filter Blanks Example: Col1 = Blank OR Col2 = Blank

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

    Filter Blank in Excel

  2. Set the criteria.

    Filter Blank in Excel

  3. Use the 'Add Criteria' button to add the 'OR Col2 = Blank' part.

    Filter Blank in Excel

    Filter Blank in Excel

  4. 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.

    Filter Blank in Excel

    If you want to verify, expand to show the unmatched rows.

    Filter Blank in Excel

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

    Filter Blank in Excel

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

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

    Filter Blank in Excel

Filtering blanks is just one small feature of DigDB powerful Complex Filter which supports wildcard and nested conditions. DigDB also allows you to select blank cells within a range.

Need more?


Features | Testimonial | Download | Purchase | FAQ | Contact (resume builder | 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.