Learn how to combine Microsoft Excel’s ROW() and ROUNDUP() functions to create a flexible serial function that returns groups of consecutive values.

When counting unique values in Microsoft Excel, use UNIQUE() as a helper function and avoid more complicated expressions.

How to Isolate a Value in Excel. Isolating values in an Excel 2007/2010 worksheet or workbook is common in both error-checking and data analysis tasks. While appropriate even for a small worksheet ...