TABLE.ORDERCOLUMN

Orders specfied table columns according to corresponding reference columns.
To create a table like cell range please refer to TABLE.UPDATE.

Syntax

=TABLE.ORDERCOLUMN(ColumnsRange, ReferenceColumnsRange)

Arguments

Name

Description

ColumnsRange

Cell range to treat like table columns. Its first row defines the column header.

ReferenceColumnsRange

Cell range which defines the order of referenced table columns. Its first row defines the column header.

Return Value

TRUE or an error value.

Example Below examples assumes following cells in range A3:D5

Col1

Col2

Col1

Col2

21

“hello”

42

“world”

42

“world”

63

“hello”

63

“!!!”

Function

Result

Description

=TABLE.ORDERCOLUMN(A3:B5,C3:C5)

TRUE

Orders Col1 as follows: 42, 63, 21

=TABLE.ORDERCOLUMN(A3:D5, C3:D5)

TRUE

Orders both columns Col1 and Col2, with Col2 as follows: world, hello, !!!