Most Excel lookup functions return the first match, but XLOOKUP can reverse the search direction to return the latest record.

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. Returning the top or bottom n ...

Summarizing data is a common task in Excel, and there’s usually more than one way to do so. Susan Harkins explains three ways to return averages for multiple groups. If you have three or more rows of ...