Dynamic Array Functions in Excel (XLOOKUP, FILTER, UNIQUE, XMATCH): Webinar Recording

We were once again joined by Excel expert, Deb Ashby, who took us through the Array Functions introduced in Microsoft Excel a few years ago.

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
• RANDARRAY
• SEQUENCE
• UNIQUE
• SORT
• SORTBY
• XLOOKUP
• XMATCH

You can follow along with this video by downloading this spreadsheet

If you are interested in learning more about Advanced Microsoft Excel. Then take a look at the following free resources:

• Predict future values using Forecast Sheet in Excel
• Getting started with 3D maps in Excel
• Getting started with Power Pivot
• Creating a Dynamic Drop Down List in Excel
• VLOOKUP for Dummies

OR, if you are using Google Sheets. Take a look at Alternatives to XLOOKUP in Google Sheets.

Adam Lacey

Adam Lacey is an Excel enthusiast and online learning expert. He combines these two passions at Simon Sez IT where he wears a number of different hats.When Adam isn't fretting about site traffic or Pivot Tables, you'll find him on the tennis court or in the kitchen cooking up a storm.