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
Dynamic Array are the new Excel functions to return the result in more than 1 cell
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
If you want to return many rows, you can't use the VLOOKUP function. But you can do the job with the FILTER function.
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
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.
How to extract only the numbers from a string in a cell? Discover the formula and the logic to reach this result.
How to extract only the numbers of your cells. The technique needs the new function of Excel 365