Dynamic Arrays Archives • My Online Training Hub

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

April 16, 2020

The Excel LET function* enables you to declare variables and intermediate calculations inside of a formula. It’s like the DAX

January 23, 2020

With Excel formulas we can easily list the first Monday date in each month, or the last Sunday, or whatever

January 8, 2020

Oh, how I wish I’d had the fortune of the new Excel XLOOKUP function back in my accounting days. The

December 11, 2019

Excel Hash is an Excel competition dreamed up by fellow Excel MVP, Oz du Soleil. It’s based on the popular

October 22, 2019

Comparing two lists is easily done with Power Query, but maybe you prefer to use a formula to extract values

January 8, 2019

I really wanted the title of this post to be “Excel Sorted Dynamic Unique List Ignoring Blanks and Errors”, but

December 6, 2018

If you’re familiar with array formulas, then the simplicity of Excel Dynamic Arrays will be a breath of fresh air.