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