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, !!!