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
Ah oke that clarifies. Try adding a Custom Column (from Query Editor, tab Add Column) with the follwing:
= if [T] = null and [S] <> null then 1 else 0Then filter out the 1's in the new column as per my previous post.
Kind regards
Djerro123
-------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Kudo's are welcome 🙂