STACK.SORT

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

=STACK.SORT(StackRange, SortSettingsRange)

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.
SortSettingsRange	Range	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

Type	Description
Boolean or Error	TRUE, if no error occurred, otherwise error value.

Examples

	A	B	C	D
1	Name	Age	City	Street
2		TRUE
3
4	Name	Age	City	Street
5	Maier	43	Sidney	Main Street
6	Miller	53	Sidney	South Street
7	Jones	45	Sidney	West Street
8	Maier	35	Sidney	High Street

Formula	Result	Comment
=STACK.SORT(A4:D8, A1:D2)	After calling STACK.DROP