6 latest Excel functions in 2022

CHOOSECOLS

Excel CHOOSECOLS function returns the specified columns from an array.

CHOOSEROWS

Excel CHOOSEROWS function returns the specified rows from an array.

HSTACK

Excel HSTACK function horizontally and sequentially appends arrays to produce a larger array.

VSTACK

Excel VSTACK function vertically and sequentially appends arrays to produce a larger array.

DROP

Excludes a number of rows or columns from the beginning or end of an array.

TAKE

Returns a number of adjoining rows or columns from the beginning or end of an array.