Hide the rows that do not match, and collect the ones that do
Inputs
| Name | Type | Required | Default | Description |
|---|---|---|---|---|
Excel Instance excelInstance | variable | Required | Not set | |
Sheet Name sheetName | string | Optional | Not set | |
Column column | string | Required | Not set | The column heading, or its letter |
Keep rows where operator | enum | Required | isError | isErrorisNotErrorequalsnotEqualscontainsdoesNotContainisEmptyisNotEmpty |
Value value | expression | Optional | Not set | Shown when operator = equals / notEquals / contains / doesNotContain |
Match capitals exactly caseSensitive | boolean | Optional | false | Shown when operator = equals / notEquals / contains / doesNotContain |
Heading Row headerRow | number | Optional | 1 | |
Output Variable outputVariable | variable | Optional | FilteredRows |
Output
$outputVariableDataTableThe matching rows, ready to write to another workbook
ColumnsArrayRowsArray
Compatibility
WindowsLinuxAttendedUnattended
Related activities
Clear Filter
Show every row again and remove the filter
Clear Range
Empty cells in place. Nothing below shifts up, so formulas pointing at those rows still point at them
Copy Range
Copy cells somewhere else, with or without their formatting. Works even when the destination overlaps the source
Find and Replace
Replace text across a range. Formula cells are left alone, so a replacement cannot quietly break a calculation
Remove Duplicate Rows
Delete repeated rows, keeping the first or the last of each. A number typed as text matches the same number
Sort Range
Sort rows by one column, then optionally a second. Whole rows move and carry their formatting, and blanks sink