As a stand-alone function, UNIQUE() returns a list of unique values using the syntax. UNIQUE(array, [by_col], [exactly_once]) The array argument is the Excel range you want to reduce to a unique list.

Let’s do an example where we will use the UNIQUE function to create a list of unique customers, as we did above, but let’s filter the list based on whether the customer is active. In cell E2, again ...

One way to get around this issue is to convert the Excel table to a range by selecting any cell in the table, and clicking ...

Before UNIQUE() was available, you might have used an advanced filter to create a unique list of values. We’ll review this feature for those of you not using Microsoft 365.

The syntax for counting the number of unique values from a list of a column using the array formula is as follows: =SUM(IF(COUNTIF(<first cell from which you count the number of unique values ...

After that, you will know how many unique values are in that column. For some of you, you could follow that until the ROWS function. Let's say your column heading is in C1, and the final value is ...

The function is designed to automatically return a list of unique values from a specified range or array. The UNIQUE function has many uses, among them identifying duplicates in Excel. Turning back to ...