SWAPVALUES
Copies the values from the given source range to the target range and vice versa. Beware that only the values are copied and not formulas. If the target range is a multiple of the source range, the target range is filled repeatedly with the source values.
Syntax
=SWAPVALUES(Range1, Range2)
Arguments
| Name | Description |
|---|---|
| Range1 | Range to exchange |
| Range2 | Range to exchange |
Return
TRUE, if successful.
Examples
| Formula | Result | Comment |
|---|---|---|
| TRUE | < |
danger
Only the values will be moved. Formulas will be removed.