Skip to main content
Version: Streamsheets 2.5

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

NameDescription
ColumnsRangeCell range to treat like table columns. Its first row defines the column header.
ReferenceColumnsRangeCell range which defines the order of referenced table columns. Its first row defines the column header.

Return

TRUE or an error value.

Examples

Col1Col2Col1Col2
21"hello"42"world"
42"world"63"hello"
63"!!!"
FormulaResultComment
=TABLE.ORDERCOLUMN(A3:B5,C3:C5)
TRUE
=TABLE.ORDERCOLUMN(A3:D5, C3:D5)
TRUE