Using Array Formulas in Excel by Chris Menard

Posted on:  12/28/2016
Using Array Formulas in Excel by Chris Menard

An array formula is a formula that can perform multiple calculations on one or more of the items in an array. Array formulas can return either multiple results or a single result. Array functions keep your Excel file smaller in size.

In general, array formulas use standard formula syntax. They all begin with an equal (=) sign, and you can use any of the built-in Excel functions in your array formulas. The key difference is that when using an array formula, you must press CTRL+SHIFT+ENTER to enter your formula. I use the Frequency function in Excel instead of multiple countif functions.

Screenshots of two array functions are shown below

Array functions 1

Array functions 2

Video of Array Functions by Chris Menard

Helpful Links on Array Functions:

https://support.office.com/en-us/article/Guidelines-and-examples-of-array-formulas-7d94a64e-3ff3-4686-9372-ecfd5caa57c7

 

Chris Menard

Chris Menard is a Microsoft Trainer (MCT) and works as a full-time Trainer at BakerHostetler - one of the largest law firms in the US. Chris runs a YouTube channel with 900+ technology videos that cover various tools such as Excel, Word, Zoom, Teams, Gmail, Copilot, Google Calendar, and Outlook. To date, the channel has helped over 20 million viewers. Menard also does 2 to 3 public speaking events yearly, presenting at the Administrative Professional Conference (APC), the EA Ignite Conference, the University of Georgia, and CPA conferences. You can connect with him on LinkedIn at https://chrismenardtraining.com/linkedin or watch his videos on YouTube at https://chrismenardtraining.com/youtube.

Categories