Scribd
Upload
20 views

10 Amazing Array Functions

This document provides summaries of 12 array functions in Excel: VSTACK, HSTACK, TOCOL, TOROW, TAKE, DROP, TEXTSPLIT, CHOOSECOLS, CHOSEROWS, UNIQUE, SORT. Each function is summarized in 1-2 sentences describing what it does. The document was written by Syed Nadeem and encourages the reader to stay connected.

Uploaded by

sey
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
20 views

10 Amazing Array Functions

This document provides summaries of 12 array functions in Excel: VSTACK, HSTACK, TOCOL, TOROW, TAKE, DROP, TEXTSPLIT, CHOOSECOLS, CHOSEROWS, UNIQUE, SORT. Each function is summarized in 1-2 sentences describing what it does. The document was written by Syed Nadeem and encourages the reader to stay connected.

Uploaded by

sey
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 12

10

Amazing
ARRAY FUNCTIONS
Released in 2022

I help Finance Professionals on their Career Journey.


Syed Nadeem
VSTACK
VSTACK returns the array formed by appending each of the array arguments
in a row-wise fashion.

=VSTACK(array1,[array2],...)

By Syed Nadeem
HSTACK
HSTACK returns the array formed by appending each of the array arguments
in a column-wise fashion.

=HSTACK(array1,[array2],...)

By Syed Nadeem
TOCOL
Returns the array in a single column.

=TOCOL(array, [ignore], [scan_by_column])

By Syed Nadeem
TOROW
Returns the array in a single row.

=TOROW(array, [ignore], [scan_by_column])

By Syed Nadeem
TAKE
Returns a specified number of contiguous rows or columns from the start or
end of an array.

=TAKE(array, rows,[columns])

By Syed Nadeem
DROP
Excludes a specified number of rows or columns from the start or end of an
array. You might find this function useful to remove headers and footers in
an Excel report to return only the data.

=DROP(array, rows,[columns])

By Syed Nadeem
TEXTSPLIT
Splits text strings by using column and row delimiters.

=TEXTSPLIT(text,col_delimiter,[row_delimiter],[ign
ore_empty], [match_mode], [pad_with])

By Syed Nadeem
CHOOSECOLS
Returns the specified columns from an array.

=CHOOSECOLS(array,col_num1,[col_num2],…)

By Syed Nadeem
CHOOSEROWS
Returns the specified rows from an array.

=CHOOSEROWS(array,row_num1,[row_num2],…)

By Syed Nadeem
UNIQUE
Returns a list of unique values in a list or range.

=UNIQUE(array, [by_col], [exactly_once])

With SORT Function

By Syed Nadeem
Stay Connected!

I help Finance Professionals on their Career Journey.


Syed Nadeem

You might also like