Filters a range by returning an array of only the changed rows, on the basis of a column tracking changed values.
XL3Filter is used in conjunction with XL3TrackChanges to track the changed rows. It's an argument for XL3RunSQLProc2 to pass a table of rows to be updated by an SQL Stored Procedure.
Syntax
XL3Filter( Input, Filter )
Parameters
| Parameter | Description |
| Input | The range to watch for changes. |
| Filter | The range (column) that contains TRUE values to corresponding changed rows. |
Example
XL3Filter(A4:E28,F4:F28)
Rows of the $A$4:$E$28 range for which the cell value is equal to TRUE for the same row in the $F$4:$F$28 range are returned.
