The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

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

Combine INDEX and MATCH: Use MATCH to find the row or column number and INDEX to retrieve the value at that position.

Discovering these differences can be important if values in one cell should match values in another. Excel has a tool that highlights differences between a row's cells regardless of the worksheet ...

TEXTBEFORE and TEXTAFTER are a few more of my favorite Excel functions to clean messy spreadsheets. Excel's newer text ...

When you need to see the last value in an Excel Table or data range, these formulas will get the job done. This walk-through details the necessary formulas and some VBA code that performs the same ...

Excel refers to rows by number and columns by letter, starting the first row at one and the first column with "A". For some purposes, this is fine, but you often want to add your own column labels ...