What is it?
The Keep Rows Where filter is used for keeping rows based on values in a specific column
How is it used?
Add Table Filter > Add Remove & Merge Rows > Keep Rows Where
To use the Keep Rows Where filter, simply specify the column you would like to target, then select the criteria of the rows you would like to keep.
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 keep rows that contain those keywords)
does not contain (this choice allows for you to insert one or more keywords to remove 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
Keep Rows Where filter:
How to Filter Rows by Values: