More Useful Array Constant Formulas
I have been recently blogging on Array Constants (see below links) and how useful they are for simpler, more maintainable and readable formulas. ttps://theexcelfactor.com/using-array-constants-formulas-logic/ https://theexcelfactor.com/using-array-constant-list-formulas/ Also I often use SUMIFS which from the top of my head came with Excel 2007. I did a job a few years ago that had another useful application of […]
More Useful Array Constant Formulas Read More »