Figure B How to use the UNIQUE () function in Excel If you’re using Microsoft 365 or one of the 2019 standalone versions of Excel, you can quickly create a dynamic list using the UNIQUE () function.

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

Combining UNIQUE with COUNTA allows you to count the number of unique entries in a dataset. Dynamic array formulas in Excel 365 enhance the flexibility and efficiency of the UNIQUE function.

Excel's Subtotal command allows you to quickly create subtotals in your sorted data, and then collapse the view to to show only the new subtotal rows. When you try to copy the subtotals by ...

The Pivot Table is a tool that Excel uses to create custom reports from your spreadsheet databases. All you need is one common, unique field. Here's how to set it up with multiple spreadsheets.