Count unique values among duplicates - Microsoft Support
There are several ways to count unique values among duplicates. You can use the Advanced Filter dialog box to extract the unique values from a column of data and paste them to a new location. Then you can use the ROWS function to count the number of items in the new range. Select the range of cells, or make sure the active cell is in a table.
more
|