Show rows with empty cells in Excel Advanced Filtering
Posted on 2011-02-23
In Excel (2007), suppose you want to use Advanced Filter to display only rows with blank or empty cells in a particular column. For example, if your table is four columns wide (A-D), with the headings in Rows 1 & 5 and the Criteria Range is A1:D2 and the List Range is A5:D100, what entry should be placed in Cell B2 so that you will end up with only those rows with empty Col B cells showing (i.e. any rows with an entry in column B will be hidden)?