What is an Array Formula in Excel??? - Tutorial

Excel tutorial on Excel array formulas 101. We’ll go over what an array formula is in Excel, how to use one, and end with some tips to keep in mind when using array formulas.

First, in Excel an array refers to a group of values – they could be in a row, column or both. An array formula is a formula that will perform calculations on the array.

Array formulas can help you use fewer formulas in your spreadsheets, potentially helping your file stay smaller and run faster as well as help you work faster. But there are a few things to consider when working with array formulas.

*FYI:

Thanks for watching this Microsoft Excel tutorial and, don’t forget, if you like this video, please “Like” and “Share” with your friends – it really helps us out 😊

Thanks!

*DISCLAIMER: This video description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. As an Amazon Associate I earn from qualifying purchases. This helps support the channel and allows us to continue to make tutorials like this. Thank you for your support!

#YAcostaTutorials

[plorandi]

Thank you for this video! Very well explained!

[allabout]

Perfect explanation. Made sense. Thanks.

[timmytesla]

Wonderful explanation. I finally understand the concept. Thank you.

[xir]

I've read about array functions without really understanding them until now, thanks to you. Definitely, the simplest is the best. What an effective way to illustrate it simply and sum it all up! You have made my day! Thanks again!

[stoleethatsme]

Great video, I thank you so much for taking the time to make and post. You are

[artgallery]

Clear explanation and easy to understand. Thanks

[stan]

This was perfectly explained. Thank you.

[josephwong]

Thanks for your sharing and explanation.

[bunjeonkookie]

What if I’m using a mobile device, I can’t press Ctrl+Shift+Enter? Is there an alternate way

[limingma]

how to transfer "=ArrayFormula(MAX((IF((AF:AF>AL172)*(AF:AF<AF172), AI:AI, 0))))" from google sheet to excel format, thank you

[matrixate]

I get the exact same results with a range. No need to hit ctrol+shift+enter.
What is the difference?

[krishyoga]

Array formula is not working in Excel 2007 and Excel 2016 . please solve the problem.