Tag Archives: Dynamic Arrays

Determine leap year with #Excel

Posted on February 29, 2020 by

Today is a special day.  Today is February 29th, which happens only once every four years.  And today is Saturday, when I usually post a new blog.  So let’s talk about how to determine if a year is leap year using … Continue reading →

Rate this:

Posted in Formula | Tagged , , , , , , , | 2 Comments

Free Template: Party Expense Calculator

Posted on December 28, 2019 by

Christmas has just passed while New Year is just around the corner.  Party must go on! As a token of appreciation for you visiting my blog, I am going to present you a free gift – Party Expense Calculator,  in … Continue reading →

Rate this:

Posted in Template | Tagged , | Leave a comment

The power of Dynamic Arrays in #Excel 365

Posted on October 26, 2019 by

… in creating dynamic drop-down with conditions Making a dynamic drop-down list is not difficult.  It may require multiple steps, helper formula and/or helper tables though.  And the number of helper tables depends on the complexity of the requirement.  I … Continue reading →

Rate this:

Posted in Excel in Action, Excel Tips | Tagged , , , , | Leave a comment

Dynamic Shrinking Dropdown with Dynamic Arrays in #Excel 365

Posted on November 14, 2018 by

The recent HOT topics about Excel should be the new Dynamic Arrays!   After watching all the amazing demonstrations about the new Dynamic Arrays, I’ve decided to sign up to the Office Insider (Fast) programme (for Office 365 subscriber only).  … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , , , | Leave a comment