This Analytics Edge wizard lets you construct one or more filters to be applied to the current table. Filters can be combined using And / Or logic, and you can choose to remove or keep the matching rows.
Typically used to remove unwanted data from a report, it can also selectively keep matching rows.
Add Filter
Column – select a column by column letter position (optionally by Name).
Criteria – select a filter criteria or test to use.
Value – enter a value to use for the filter test. For text columns, optionally check Case sensitive to match upper and lower case letter exactly.
And – add the filter rules (Column, Criteria and Value) to the list using AND logic, meaning both this rule in addition to a previous rule entered are required to cause a match.
Or – add the filter rules (Column, Criteria and Value) to the list using OR logic, meaning either this rule or a previous rule entered will cause a match.
Filter Rules
Keep Matches – keep rows that match all of the filter rules.
Remove Matches – remove rows that match all of the filter rules.
Options
Remove empty rows – if a row contains no information in any of the columns, remove it.
Remove empty columns – if a column contains no information in any of the rows, remove it.
Stop macro if no data – if the table is empty, then stop the macro. This does not cause an error condition, so other macros will continue to run if Refresh All or Scheduled refresh was used.
Blog article: Using the Filter Function