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!

VLOOKUP with Array Constants – Data Analytics

Combine ranges and arrays in Excel: VSTACK & HSTACK functions

A beginners guide to Excel array formulas

Array formulas and functions in Excel - examples and guidelines

Dynamic array formulas in Excel

Excel array formula - javatpoint

How to Create an Array Formula in Excel? - GeeksforGeeks

Array formulas and functions in Excel - examples and guidelines

Array formulas and functions in Excel - examples and guidelines

Stacking (Appending) Arrays/Ranges in Excel: Formulas versus Functions Shootout