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.

The UNIQUE function in Excel 365 is designed to extract distinct values from a given range of data. It generates a list of unique entries without modifying the original dataset, making it an ...

The dynamic array function, UNIQUE () has been around for a while, so it’s possible that you already know how to use it. If that’s the case, feel free to skip this section.

Input the ROWS function into that cell using the first and last cells of that column, not including the column heading. After that, you will know how many unique values are in that column.