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