Filter based value in multiple columns

M

Melissa

How can I filter my table to only show rows where cells in Column A AND
Column B are blank? It's possible for a cell in Column A to be blank while
the corresponding cell in Column B is not, and vice versa.
 
D

Dan

You could add a column header first then use "AutoFilters" from "Data ->
Filter-> AutoFilter"

Select which column you need to be blanks, say column A with required
criteria (you case, "BLANK") from header dropdown icon. Then set the other
column criteria.
 
Top