dsReplace


The dsReplace is a special spreadsheet function supplied by Deriscope that creates a data array by replacing the contents of the specified subset of the source range with those of the target range.

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 2 arguments with two additional optional arguments and has the following form:

=dsReplace( source, target, [startRow], [startColumn] )

The arguments are as follows:

source: The range supplying the original data before the replacement takes place.

target: The range supplying the data that are used as the replacement for the specified subset of the source data.

startRow: Optional integer (default = 1) that identifies the row of the cell in the source range that will hold the top/left cell of the target range. 1 corresponds to the top row of the source range.

startColumn: Optional integer (default = 1) that identifies the column of the cell in the source range that will hold the top/left cell of the target range. 1 corresponds to the leftmost column of the source range.