
October 6, 2022
New Array Shaping Excel Functions
Microsoft recently released 11 new Excel functions for shaping arrays (data). I already covered VSTACK and HSTACK which was super
Read MoreOctober 6, 2022
Microsoft recently released 11 new Excel functions for shaping arrays (data). I already covered VSTACK and HSTACK which was super
Read MoreApril 16, 2020
The Excel LET function* enables you to declare variables and intermediate calculations inside of a formula. It’s like the DAX
Read MoreJanuary 23, 2020
With Excel formulas we can easily list the first Monday date in each month, or the last Sunday, or whatever
Read MoreJanuary 8, 2020
Oh, how I wish I’d had the fortune of the new Excel XLOOKUP function back in my accounting days. The
Read MoreDecember 11, 2019
Excel Hash is an Excel competition dreamed up by fellow Excel MVP, Oz du Soleil. It’s based on the popular
Read MoreOctober 22, 2019
Comparing two lists is easily done with Power Query, but maybe you prefer to use a formula to extract values
Read MoreJanuary 8, 2019
I really wanted the title of this post to be “Excel Sorted Dynamic Unique List Ignoring Blanks and Errors”, but
Read MoreDecember 6, 2018
If you’re familiar with array formulas, then the simplicity of Excel Dynamic Arrays will be a breath of fresh air.
Read More