Using array constants in Excel

Every once in a while I learn something completely new that really boggles my mind! In this case the Chess world overlaps the Microsoft Excel world!

excel - Make an array of constant values of the height of a spilled range - Stack Overflow

How to Create an array constant from cell values in MS Excel « Microsoft Office :: WonderHowTo

Working With Excel Dynamic Arrays

Excel Formulas - Array Formulas

COUNTIF with array constant — Smartsheet Community

Array Constants Spreadsheets Made Easy

How Pros Dynamically Resize & Fill VBA Array Variables (Multiple Scenarios)

Array Formulas in Excel - GeeksforGeeks

Array formulas and functions in Excel - examples and guidelines

Use array constants in array formulas - Microsoft Support

Array Formulas — Blueberry

i-nth - Excel array formulas, functions and constants - examples and guidelines

Excel Array constant

Array formulas and functions in Excel - examples and guidelines