HDTutorial
EN
How to Create Array Formulas in Excel

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to Create Array Formulas in Excel

124,271 views November 11, 2018 3:28

Watch on YouTube
ChannelVertex42

Description from the creator

Learn how to create an array formula in Excel using CTRL + SHIFT + ENTER, including how to create both single and multi-cell array functions. Download the example file: vertex42.com/blog/excel-formulas/array-formula-…

0:32 Create a Multi-Cell Array Formula (output more than one value)
1:29 Single-Cell Array Formula (output to a single cell)
1:48 Nested IF Array Formula example

Don't Forget to Subscribe! 😃

FOLLOW VERTEX42:
Twitter: twitter.com/vertex42
Instagram: instagram.com/vertex42/
Facebook: facebook.com/vertex42/
Pinterest: pinterest.com/vertex42/
Website: vertex42.com/

About this tutorial

Vertex42 published this 3:28 video tutorial on November 11, 2018. It has been watched 124,271 times on YouTube.

Channel
Vertex42
Category
Education
Duration
3:28
Published
November 11, 2018
Views
124,271
Likes
413

Tags

Share

This tutorial in other languages