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

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

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

This step-by-step guide will teach you how to create a dependent drop down list in Excel. You need to use the UNIQUE and FILTER functions.

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

Learn how to sort your data dynamically in Excel using the SORT function. Sort single columns or entire tables with ease.

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

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