There are a few ways to count unique values in Excel. One way is to use the COUNTIF function. The COUNTIF function counts the number of cells in a range that contain a specific value. The range can be a column or a row. The function can also be used to count the number of cells that are not equal to a specific value. The following example counts the number of unique values in the column A.
=COUNTIF(A:A,A)
This function will count the number of times the value in A appears in the column A.
Another way to count the number of unique values in a column is to use the FREQUENCY function. The FREQUENCY function counts the number of times a value appears in a range of cells. The range can be a column or a row. The following example counts the number of unique values in the column A.
=FREQUENCY(A:A)
This function will count the number of times the value in A appears in the column A.