Dynamic Arrays Archives • My Online Training Hub

August 5, 2025

Excel LET Function

Have you ever written a long Excel formula that broke the moment you changed a single value? The LET function

October 6, 2022

Microsoft recently released 11 new Excel functions for shaping arrays (data). I already covered VSTACK and HSTACK which was super

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.