Difference between revisions of "XL3Filter"
(Created page with "Returns an array of changed rows in a range based on a column that tracks changed values (used in conjunction with XL3TrackChanges to track the changed rows and as an argu...") |
|||
| Line 1: | Line 1: | ||
| − | Returns an array of changed rows in a range | + | Returns an array of changed rows in a range on the basis of a column that tracking changed values (used in conjunction with [[XL3TrackChanges]] to track the changed rows and as an argument for [[XL3RunSQLProc2]] to pass a table of rows to update for an SQL Stroed Procedure. |
==Syntax== | ==Syntax== | ||
Revision as of 14:49, 11 October 2021
Returns an array of changed rows in a range on the basis of a column that tracking changed values (used in conjunction with XL3TrackChanges to track the changed rows and as an argument for XL3RunSQLProc2 to pass a table of rows to update for an SQL Stroed Procedure.
Contents
[hide]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. |
Examples
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.
