STACKSORT

This function uses the criteria range to select and copy one or multiple rows from the StackRange to the TargetRange. Optionally it deletes all found records after the extract operation (remaining rows all move up!)

Syntax

=STACKSORT(StackRange, SortSettingsRange)

Arguments

NameDescription
StackRangeRange, where the source range items are added to. The first row of the StackRange is a title range and remains unchanged.
SortSettingsRangeThe SortSettingsRange has two rows. In the first row you have all or part of the labels of the StackRange (may be in another order). The cells in the second row either contain TRUE or FALSE. TRUE is ascending, FALSE is descending. If you have more than two rows in the SortSettingsRange then it is first sorted after the field name in the second row, then after the field name in the third row, etc.

Return Value

TRUE, if no error occurred, otherwise error value.

Example

FunctionResult
=STACKSORT(A5:D9,A2:D3)
After calling STACKDROP