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: https://www.vertex42.com/blog/excel-formulas/array-formula-examples.html
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: https://twitter.com/vertex42
Instagram: https://www.instagram.com/vertex42/
Facebook: https://www.facebook.com/vertex42/
Pinterest: https://www.pinterest.com/vertex42/
Website: https://www.vertex42.com/
