Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
#2
![]() |
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Filtering on multiple columns | Excel Discussion (Misc queries) | |||
Convert 1 row of data into Multiple columns | Excel Discussion (Misc queries) | |||
Multiple columns in a pivot table | Excel Discussion (Misc queries) | |||
Filtering Text Data from Multiple columns | Excel Worksheet Functions | |||
Drop-down selection fills data across multiple columns | Excel Discussion (Misc queries) |