What is it?
The Remove Rows Where filter is used for removing rows based on values in a specific column
How is it used?
Add Table Filter > Add Remove & Merge Rows > Remove Rows where
To use the Remove Rows Where filter, simply specify the column you would like to target, then select the criteria of the rows you would like to remove.
You can choose from the following:
Strings:
has a value
does not have a value
contains (this choice allows for you to insert one or more keywords to remove rows that contain those keywords)
does not contain (this choice allows for you to insert one or more keywords to only keep the rows that contain those keywords)
Number Formats:
is an integer number (0-9)
is not an integer number
is a float number (0-9,.)
is not a float number
is an amount (0-9$€£¥)
is not an amount
is a date
Word Counts:
has only one word
has multiple words
RegEx Patterns:
matches a pattern
does not match a pattern
How to Remove Rows from a Table: