Forum Discussion
Remove row with two filters
How do I remove rows following two steps. First: filter all null cells in collum T Second: filter all cells that contains any value in collum S then delete rows
Anonymous in formula bar update your filter expression as below, first filter column T by selecting a value and then on filter row step, update the expression as below
([T] <> null and [S]<>null) or [S]=null)
Doesn't work because row 204, 205, 206... will be deleted and I just want delete rows 197, 198 and 203. Following the steps
Anonymous in formula bar update your filter expression as below, first filter column T by selecting a value and then on filter row step, update the expression as below
([T] <> null and [S]<>null) or [S]=null)