STACK.DROP
This function removes one row from the Stack. All rows below move one row up.
Syntax
=STACK.DROP(StackRange, [Position], TargetRange)
Arguments
| Name | Type | Description |
|---|---|---|
| StackRange | Range | Range, where the source range items are added to. The first row of the StackRange is a title range and remains unchanged. |
| Position (optional) | Position defines, which row is dropped. If Position = -1 all rows (except the title row) are dropped. If Position = 0 the last used row is dropped. If Position = 1 the first row (after the title row) is dropped. Any value between 2 and N (last row) can also be specified. Default value: 1 | |
| TargetRange | Range | If TargetRange is specified and if a row has to be dropped, the row is copied to the TargetRange. TargetRange must have two rows, the first row has labels also found in Stackrange (not necessarily all and maybe not in the same order!). The dropped values are copied to the matching columns in the TargetRange. If no row is dropped, the values in the second row of TargetRange are blanked out. Important: Before copying to the TargetRange all existing values in TargetRange are deleted (not the labels row!) |
Return
| Type | Description |
|---|---|
| Boolean or Error | TRUE, if no error occurred, otherwise error value. |
Examples
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Name | Age | City | Street |
| 2 | Maier | 43 | Sidney | Main Street |
| Formula | Result | Comment |
|---|---|---|
| After calling STACK.DROP  |