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

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