Skip to main content


This function rotates the complete stack by Pos positions up or down.


=STACKROTATE(StackRange [, Position, TargetRange])


StackRangeRange, where the source range items are added to. The first row of the StackRange is a title range and remains unchanged.
PositionOptional. 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. Pos defaults to 1.
TargetRangeIf 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 Value

TRUE, if no error occurred, otherwise error value.


After calling STACKROTATE