Excel’s UNIQUE function allows users to extract unique values from a dataset, making it easier to identify and remove duplicates.

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

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.

The UNIQUE function in Excel 365 is designed to extract distinct values from a given range of data.

Both function combinations will skip over any blank row and will not count towards the running total of unique values, as there is no value to be counted.

In Excel 365, the “Unique” function filters out repeated items, showing only those appearing exactly once, while the “Distinct” function lists all distinct items, regardless of frequency.

Well-known functions like UNIQUE, COUNTIF, and SORTBY can be used with the spilled range operator to generate dynamic, sortable lists. Using a hash symbol (#)—also known as a spilled range ...

The UNIQUE function has many uses, among them identifying duplicates in Excel. Turning back to the same transaction report, let’s walk through how to use the UNIQUE function to identify duplicates.