Quick LinksUsing a Column in a Formatted Excel TableUsing a Column in an Unformatted DatasetMicrosoft Excel's Data Validation ...

Creating a list of duplicate values that’s separate from the source data is a bit more difficult. Fortunately, thanks to Excel’s FILTER() dynamic array function, creating a list of duplicate ...

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.

The syntax for counting the number of unique values from a list of a column using the array formula is as follows: Eg. Let us say we have a list of sports and the players who won at each sport.