Filter Blank in Excel

DigDB

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

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 Blank in Excel
Practice file - filter-blank-demo.xls (16k)

Filter Blanks Example: Col1 = Blank OR Col2 = Blank

Click into any cell within your table area. Invoke 'DigDB->Complex Filter->Filter...'. .
Set the criteria.
Use the 'Add Criteria' button to add the 'OR Col2 = Blank' part.
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.

If you want to verify, expand to show the unmatched rows.
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.

You can click 'DigDB->Clear Filter' to get rid of the filter and the '+', '1', '2' signs to go back the simple list.
Result in a new sheet. The sheet will be automatically created.

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?

Browse the complete list of DigDB's powerful features listed on the front page.
If you see errors or things not working, check out our error reference page.

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 and the Office logo are trademarks or registered trademarks of
Microsoft Corporation in the United States and/or other countries.