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.
"Melissa" wrote:
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.
|