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.

SEE: How to use Find All to manipulate specific matching values in Excel (TechRepublic) Listing A shows a macro that automates the simple two-column sort that we ran in the last section.

To pull data from another sheet in Excel, use cell references, use the VLOOKUP function, or use the INDEX and MATCH functions.

Learn how to dynamically insert blank rows in Excel to improve data readability, organization, and clarity with advanced techniques.

In this quick video tutorial, Excel Off The Grid explains how to harness the power of dynamic arrays, custom functions, and innovative Excel tools to eliminate blank rows without lifting a finger.