Filter rows/cells with formula
Filter rows from the dataset based on the result of a formula. Alternatively, clear content from matching cells rather than filter the rows.
The row/cell matches if the result of the formula is considered as “truish,” which includes:
-
A true boolean
-
A number (integer or decimal) that is not 0
-
The string “true”
Options
Action
Select the action to perform on matching (in range) rows or cells:
-
Keep matching rows only
-
Remove matching rows
-
Clear content of matching cells
-
Clear content of non-matching cells