Requirement: Count Unique data in Excel using UNIQUE and COUNTIF functions
Have a list which consists of number of data with duplicates values, Add on Unique formula for colors to remove duplicates and add CountIf formula to get the count value of the colors(list).
=UNIQUE(A2:A36)
=COUNTIF($A$2:$A$36, C2)
Follow the same formula for Count column, by changing the Color column value row number.