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.

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.

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.

What is the SPILL error in Excel?

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

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