L_FLIP, L_FLIPUD, L_FLIPLR

=L_FLIP(array, [dimension])
=L_FLIPUD(array)
=L_FLIPLR(array)

Download the Template

In the template file, navigate to the Arrays worksheet to see the L_FLIP, L_FLIPUD, L_FLIPLR function in action.

Description

Reversing the order of the the rows or columns of an array can be done using CHOOSEROWS, CHOOSECOLS and the SEQUENCE functions. However, remembering how to do it may take time. FLIP is the more general function because it lets you choose either dimension=1 (same as FLIPUD) or dimension=2 (same as FLIPLR). FLIPLR means "flip left-right." FLIPUD means "flip up-down."

L_FLIPLR(array) = CHOOSECOLS(array,SEQUENCE(1,COLUMNS(array),COLUMNS(array),-1))
L_FLIPUD(array) = CHOOSEROWS(array,SEQUENCE(ROWS(array),1,ROWS(array),-1))

If your data is already sorted, then changing the sort direction may be the same thing as FLIP. However, if you specifically do NOT want to sort your data and ONLY want to reverse the order, that is where FLIP is handy.

Lambda Formula

This code for using L_FLIP, L_FLIPUD, L_FLIPLR in Excel is provided under the License as part of the LAMBDA Library, but to use just this function, you may copy the following code directly into your spreadsheet.

Name: L_FLIP
Comment: Reverses the order of the rows, unless it is a single row or dimension=2, then reverses the columns
Refers To:
=LAMBDA(array,[dimension],
LET(doc,"https://www.vertex42.com/lambda/flip.html",
    dimension,IF(ISOMITTED(dimension),1,dimension),
    rows,ROWS(array),
    cols,COLUMNS(array),
    IF(OR(dimension=2,rows=1),
        CHOOSECOLS(array,SEQUENCE(1,cols,cols,-1)),
        CHOOSEROWS(array,SEQUENCE(rows,1,rows,-1))
    )
)

Name: L_FLIPUD
Comment: Reverses the order of the rows of an array
Refers To:
=LAMBDA(array,
LET(doc,"https://www.vertex42.com/lambda/flip.html",
    rows,ROWS(array),
    CHOOSEROWS(array,SEQUENCE(rows,1,rows,-1))
))

Name: L_FLIPLR
Comment: Reverses the order of the columns of an array
Refers To:
=LAMBDA(array,
LET(doc,"https://www.vertex42.com/lambda/flip.html",
    cols,COLUMNS(array),
    CHOOSECOLS(array,SEQUENCE(1,cols,cols,-1))
))

/**
* Reverses the order of the rows, unless it is a single row or 
* dimension=2, then reverses the columns
*/
L_FLIP = LAMBDA(array,[dimension],
LET(doc,"https://www.vertex42.com/lambda/flip.html",
    dimension,IF(ISOMITTED(dimension),1,dimension),
    rows,ROWS(array),
    cols,COLUMNS(array),
    IF(OR(dimension=2,rows=1),
        CHOOSECOLS(array,SEQUENCE(1,cols,cols,-1)),
        CHOOSEROWS(array,SEQUENCE(rows,1,rows,-1))
    )
));

/**
* Reverses the order of the rows of an array
*/
L_FLIPUD = LAMBDA(array,
LET(doc,"https://www.vertex42.com/lambda/flip.html",
    rows,ROWS(array),
    CHOOSEROWS(array,SEQUENCE(rows,1,rows,-1))
));

/**
* Reverses the order of the columns of an array
*/
L_FLIPLR = LAMBDA(array,
LET(doc,"https://www.vertex42.com/lambda/flip.html",
    cols,COLUMNS(array),
    CHOOSECOLS(array,SEQUENCE(1,cols,cols,-1))
));

Name: L_FLIP
Description: Reverses the order of the rows, unless it is a single row or dimension=2, then reverses the columns
Arguments: array, dimension
Function:

LET(doc,"https://www.vertex42.com/lambda/flip.html",
    dimension,IF(ISBLANK(dimension),1,dimension),
    rows,ROWS(array),
    cols,COLUMNS(array),
    IF(OR(dimension=2,rows=1),
        CHOOSECOLS(array,SEQUENCE(1,cols,cols,-1)),
        CHOOSEROWS(array,SEQUENCE(rows,1,rows,-1))
    )
)

FLIP Examples

Example

Use FLIP, FLIPLR or FLIPUD to reverse the order of rows and columns of the array shown in the image.

Test: Copy and Paste the LET function into a cell
=LET(
    array, {"A1","B1","C1"; "A2","B2","C2"; "A3","B3","C3"},
    L_FLIP(array,1)
)

=LET(
    array, {"A1","B1","C1"; "A2","B2","C2"; "A3","B3","C3"},
    L_FLIPLR(array)
)

=LET(
    array, {"A1","B1","C1"; "A2","B2","C2"; "A3","B3","C3"},
    L_FLIPUD(array)
)