By SCIt is used to find unique values in a row or column and results list of distinctive element.
To find unique values in column you can use this formula and by using it with counta formula in excel, we can count the numbers of unique values in column as shown in image below.
Unique formula in excel:
