Skip to main content
Version: Streamsheets 2.4

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

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 Value

TRUE or an error value.

Example Below examples assumes following cells in range A3:D5

Col1Col2Col1Col2
21"hello"42"world"
42"world"63"hello"
63"!!!"
FunctionResultDescription
=TABLE.ORDERCOLUMN(A3:B5,C3:C5)TRUEOrders Col1 as follows: 42, 63, 21
=TABLE.ORDERCOLUMN(A3:D5, C3:D5)TRUEOrders both columns Col1 and Col2, with Col2 as follows: world, hello, !!!