ARRAYSWAP

Exchanges the positions of two items in an array.

Syntax

=ARRAYSWAP("Array","Index from","Index to")

Example

In cell F19, you have this array, created with the ARRAY function:

#(123,789,TRUE,FALSE,"Test","a","b","c")

This function exchanges the positions of the True and False elements in the array:

=ARRAYSWAP(F19,3,4)

Related topics