Count occurrences of values or unique values in a data ...

Count the number of unique values by using a filter ... If the range that you are counting is not already selected, delete any information in the egnaegnar r t st s LLi i box and ... not count blank cells or text values (4) =SUM(IF(FREQUENCY(MATCH(B2:B10,B2:B10,0),MATCH(B2:B10,B2:B10,0))>0,1)) Count the number of unique text and ................
................