dsTrimRows


The dsTrimRows is a special spreadsheet function supplied by Deriscope that creates a data array out of the contents of the source range by keeping or trimming away selected rows.

Visit the
Deriscope Excel Functions for practical tips on how to generate demos of this and the other Deriscope functions on the spreadsheet.

It takes at least 4 arguments with two additional optional arguments and has the following form:

=dsTrimCols( source, include, matchType, matchValues, [matchLineIndex], [ignoreCase] )

The arguments are as follows:

source: The range supplying the original data.

include: Boolean. True means the specified rows must be included in the output array and effectively all other rows are trimmed away. False means they must be excluded from the output array.

matchType: Text defining the type of criteria used in locating the affected rows. Possible values are: ByIndex, ByExactMatch, ByLessMatch, ByGreaterMatch, ByPartialMatch, ByPrefixMatch, BySuffixMatch

matchValues: If matchType = ByIndex, a two-column range containing integers, where the two integers in each row define a range of processed rows. Otherwise a single column with the required reference values.

matchLineIndex: Optional integer (default = 1) that identifies the row in the source range that contains the reference values that are compared against the matchValues in order to locate the processed rows. 1 corresponds to the leftmost column of the source range.

ignoreCase: Optional boolean that dictates whether string comparisons should be case sensitive or not. If not specified, the default is true, meaning not case sensitive.