Dynamic arrays

Create a weekly calendar with just one formula in Excel

Generate a dynamic weekly calendar in Excel with this single powerful formula SEQUENCE. Easy and efficient

UNIQUE is a new Excel function to remove automatically the duplicates in a list of data. It's amazing how simple is it to use this function

SPILL is a new Excel error that occurs when Excel hasn't had enough space to return the result.

The SORT functions in Excel has been created to sort your data dynamically. Let's see how to use it and improve your dashboard

The FILTER function of Excel returns all the rows corresponding to a specific criteria. It's possible because of the Dynamic Arrays of Microsoft 365

Convert Number to Words is now possible with Excel 365 and the LET function

Create a depending drop down menu in Excel has become easier with the new functions FILTER and UNIQUE of Microsoft 365.

Discover How to Extract Only the Unique Values of a list of data in Excel with the UNIQUE function.