FLIPCELLS

Flips a range of values in a specified direction.

Syntax

FLIPCELLS(range; direction)

• range - the range which should be flipped - Value type: range

• direction - the direction in which the range should be flipped - Value type: constant (optional, default: horizontal)

  Possible values are

  • horizontal - flip the range horizontally (reverse order of columns)

  • vertical - flip the range vertically (reverse order of rows)

  • both - flip the range both horizontally and vertically

Remarks

• This function is particularly useful in combination with MOVECELLS to guarantee that leaf cells of a column-based hierarchy appear in the first column.

• Common use cases include easier retrieval of leaf elements from a column-based hierarchy and quick reversion of row order.