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