ARRAYSWAP

This function creates an array in which the positions of two items in an existing array are exchanged.

Syntax

=ARRAYSWAP(array,index,index)

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)