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

Name

Description

StackRange

Range, where the stack range resides. The first row of the StackRange is a title range and remains unchanged.

SortSettingsRange

The 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

Function

Result

=STACKSORT(A5:D9,A2:D3)

STACKSORT1

After calling STACKSORT

STACKSORT2