Syntax

GROUP_SORT_ASC(<any>)

Description

Sorts groups in ascending order.

This is a group series function.

The sort results can't be guaranteed to transfer from one sheet to another due to the nature of distributed systems. Ensure the sort was made on the sheet where it is being referenced.

Example

Given the following data:

Group	Users
group1	5
group1	8
group2	9
group1	7
group1	9
group2	12
group2	10
group2	4
group1	2
group1	6

First create a group using GROUPBY(#RawData!Group).

Group
group1
group2

Then use the GROUP_SORT_ASC(#RawData!Users). The result is the column values displayed in ascending order in relation to the GROUPBY() column.

Group	Ascending_Users
group1	2
group1	5
group1	6
group1	7
group1	8
group1	9
group2	4
group2	9
group2	10
group2	12

Browser not supported