|
REVERSE.ARRAY Function
Reverses the rows or columns (or both) of an array.
REVERSE.ARRAY is a multi-threaded, non-volatile array function.
REVERSE.ARRAY Syntax
REVERSE.ARRAY (InputArray, ReverseRows, ReverseCols)
InputArray
An expression or range that returns an array of values.
ReverseRows (Optional, default TRUE)
TRUE to reverse the rows of the array so that the last row becomes the first row.
ReverseCols (Optional, default TRUE)
TRUE to reverse the columns of the array so that the last column becomes the first row.
REVERSE.ARRAY Examples
S27:U29 contains
.png)
{= REVERSE.ARRAY(S27:U30,TRUE,FALSE)} reverses the rows but not the columns and returns
.png)
{=REVERSE.ARRAY(S27:U30,FALSE,TRUE)} reverses the columns but not the rows and returns
.png)
{=REVERSE.ARRAY(S27:U30,TRUE,TRUE)} reverses both rows and columns and returns
.png)
By comparison {=TRANSPOSE(S27:U30)} returns
.png)
|
