Merge
The Merge() function merges one or more ranges of cells.
Syntax
Merge ()
| Ranges | The ranges of cell to merge |
Note:
Input parameters can consist of Quintessence functions. This includes functions that return ranges in cases where a parameter value can be a range.
Examples
Note:
How your system administrator configured Quintessence determines which function parameters are required. In most implementations, administrators configure functions so that certain parameters default to specific values when left blank.
In this example, three ranges of cells are merged. These ranges are passed to the Merge function as an array. Note that the sheet name needs to be specified in the input range, as the function may be on a different worksheet from the cells that are to be merged.
| Ranges to merge | Merge function with an array of ranges as input | ||||
| AAA | =Merge(“Final!A2:A4,Final!C7:B5,Final!B9:D9”) | ||||
| BBB | |||||
| CCC | |||||
| 1 | 2 | ||||
| 3 | 4 | ||||
| 5 | 6 | ||||
| X | Y | Z | |||
Note that the value in the first cell of the range is the value that is retained after the merge operation.
| Result | Merge status | ||||
| AAA | TRUE | ||||
| 1 | |||||
| X | |||||