Dynamic arrays

Mastering the SORT Function in Excel

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

Unlock the potential of Excel by learning how to create a weekly calendar with just one formula. Step-by-step guide in this article.

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

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

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

Discover what causes the #SPILL! error in Excel and how it relates to dynamic array formulas and insufficient space for result display.