How to return the top or bottom n records without a filter or PivotTable in Excel Your email has been sent Returning the top or bottom n records of a data set in Excel isn’t difficult, and there are ...

One of the most underused lookup and reference functions in Microsoft Excel is the DROP function. This powerful yet simple ...

Locating missing sequential numbers can be an arduous task when working with long lists of data. For example, you might want to locate business check numbers that haven't been logged into a balance ...

VSTACK and HSTACK are dynamic array functions, meaning the result spills from the cell in which you type the formula, and any changes to the data in the source arrays are reflected in the stacked ...

The Freeze feature in Excel allows you to scroll down through hundreds of rows and still see the original headers or field names in row 1, or scroll over hundreds of columns and still see the data ...