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

If you wish to count the same or duplicate values in a column only once in Excel or the count of occurances of duplicate values, read this article.

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

Learn how to count the number of unique and distinct values in a column based on data in another column using array in Microsof Excel.

You can sum a series of numbers in Microsoft Excel manually by typing in a simple formula, or automatically with a tool.

If you have a lengthy column of numbers that you need to multiply by a percentage, Excel includes tools to instantly apply the product to the entire range of cells in the column.

Creating a list of duplicate values that’s separate from the data source is easier than ever thanks to Microsoft Excel's FILTER() function.

You can filter data in Excel based on either certain parameters in columns or over the whole sheet, and you can later unfilter the sheet.

Learn Excel 365 calculated columns to enhance your data analysis skills with dynamic formulas, cross-table calculations for real-time insight ...