This one Excel symbol will change how you write formulas
www.makeuseof.com/excel-symbol-change-how-write-formulas/
Dynamic array formulas and spilled array behavior – Microsoft Support
support.microsoft.com/en-au/office/dynamic-array-formulas-and-spilled-array-behavior-205c6b06-03ba-4151-89a1-87a7eb36e531
Excel Dynamic Array; A Beginner’s Tutorial | GoSkills
www.goskills.com/Excel/Resources/Excel-dynamic-arrays#:~:text=Excel%20has%20introduced%20a%20spill,D5%20with%20the%20expression%20D2%23.