Count cells that are numbers and unique
{=SUM(IF(FREQUENCY(CellRange,CellRange)>0,1,0))} = #N/A
This formula does not work when some of the cells contain error values.
Related Formulas
Count cells that are unique text strings
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top