View Single Post
  #2   Report Post  
Dan
 
Posts: n/a
Default

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.