Well it’s the Boxing Day holiday here in Aussieland 2017 and one of our traditions is watching the Test Cricket in Melbourne that always starts on Boxing Day. Fantastic stuff. But also, this is the time of the year to think of New Year’s Resolutions. If you are not using Tables in Excel, this would […]
Make Using Tables your New Year’s Resolution Read More »
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 »