Microsoft Excel's new dynamic array functions make complex calculations easier than ever before.

You can do this using the ability in Excel to continue a sequence down a spreadsheet column or using the function Row in Excel.

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.

Excel ROW function will return the row number of a reference. ROWS will return the number of rows in a column. Learn how to use the Row and Rows function in Excel.