Count the number of unique values by using a filter
- Select the range of cells, or make sure the active cell is in a table. ...
- On the Data tab, in the Sort & Filter group, click Advanced. ...
- Click Copy to another location.
- In the Copy to box, enter a cell reference. ...
- Select the Unique records only check box, and click OK.
Is there a count unique function in Excel?
You can use the combination of the SUM and COUNTIF functions to count unique values in Excel. The syntax for this combined formula is = SUM(IF(1/COUNTIF(data, data)=1,1,0)). Here the COUNTIF formula counts the number of times each value in the range appears.
How do I count unique pairs in Excel?
Select a blank cell besides the columns you will count unique rows, says Cell E2, type the formula =A2&B2&C2 into it, and then drag the cell's AutoFill Handle down to the range as you need.
