TABLE.ORDERCOLUMN

Orders specified 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	Type	Description
ColumnsRange	Range	Cell range to treat like table columns. Its first row defines the column header.
ReferenceColumnsRange	Range	Cell range which defines the order of referenced table columns. Its first row defines the column header.

Return

Type	Description
Boolean or Error	TRUE or an error value.

Examples

Col1	Col2	Col1	Col2
21	"hello"	42	"world"
42	"world"	63	"hello"
63	"!!!"

Formula	Result	Comment
=TABLE.ORDERCOLUMN(A3:B5,C3:C5)	TRUE
=TABLE.ORDERCOLUMN(A3:D5, C3:D5)	TRUE