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)
Have you tried In edit query mode? You have options for row operations. On home tab, edit query option.