Dynamic Array Functions in Excel: XLOOKUP, FILTER, UNIQUE, XMATCH

In this recorded Excel tutorial, Excel expert, Deb Ashby, who took us through the Array Functions in Excel introduced in Microsoft a few years ago.

✅To download the Excel file and follow along, go here ➡️

These functions replace and improve upon some existing functions (XLOOKUP instead of INDEX, MATCH). In this Dynamic Array session Debs covers the following Excel Functions:

- FILTER Function in Excel
- RANDARRAY Function in Excel
- SEQUENCE Function in Excel
- UNIQUE Function in Excel
- SORT Function in Excel
- SORTBY Function in Excel
- XLOOKUP Function in Excel (including XLOOKUP vs. INDEX MATCH)
- XMATCH Function in Excel

💻 Watch more free popular training tutorials from Simon Sez IT:

🔥Check out our FREE 300+ hour training course playlist here ➡️

💬Stay in touch!

🔔 Subscribe to our channel:

If you enjoyed the video, please give a thumbs up 👍🏽 ;-)

[DavidGzirishvili]

Why to use array trick (with curly brackets) if the calculation can be done by SUMPRODUCT?

[berturselman]

Hi Debby,

Thanks for this wonderfull course again.

I have a problem with the Control+Shift+Enter function. Any idea how to solve it?

Kind regards
Bert

[fayazali]

How can use filter formula in Excel 2019 version??

[grahamhilldrup]

Once again, very informative. Thank you.

[Colin-Fenix]

Fortunately there is playback speed… so slow at normal speed… too much babble.

[minafuchi]

Hi good morning
IAM from Nepal I watched all of your video it is a great job for students.iam a not students IAM a 35 years.i work in a larger company in warehouse really helpful yours video for me .
I request to you can you make about DXLOOKUP Function formula