Named Arrays

Something I have learned recently in the Formulas & Functions course from Maven Analytics is named arrays.

I had no idea that you could name a range in Excel, and use that name to refer to it in formulas!

Now I know.