Dynamic Arrays

Learn how to use dynamic arrays in Excel to return results in multiple cells. Explore the power of these new functions for advanced data manipulation.

CHOOSECOLS function in Excel

Discover the power of CHOOSECOLS and how it works with FILTER and GROUPBY functions to enhance data management.

Adding Headers to Tables Built with Dynamic Arrays

Discover the easy way to add headers to dynamic arrays in Excel. This will instantly improve the usability and visual appeal of your data.

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.

The FILTER Function in Excel

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

Extract only the numbers of a cell in Excel

Want to extract numbers from cells with mixed characters? Discover the step-by-step process using the SEQUENCE and FILTER functions.

UNIQUE Function – Remove duplicates with formulas

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

Find Items That Appear Only Once

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

How to return multiple rows with VLOOKUP

If you want to return many rows, you can't use the VLOOKUP function. But you can do the job with the FILTER function.

How to create Dependent Drop down List in Excel?

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.

What is the SPILL error in Excel?

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

Dynamic Arrays

Categories

Dynamic Arrays