There are lots of ways to return the top or bottom n records from a data set in Microsoft Excel, but the new dynamic array functions make doing so easier than ever.

Microsoft Excel's dynamic array function XLOOKUP() might completely replace VLOOKUP() and HLOOKUP().

Learn how to extract specific data from Excel cells using formulas, tools, and techniques to clean and organize messy datasets.

People who use Excel can use Copilot Pro to convert data into a table, create formulas, analyze data, sort and filter information, generate charts, and more.