The following formula will count unique numbers in a column – it does not count text.
=SUM(IF(FREQUENCY(A2:A10,A2:A10)>0,1))
Excel 2013 – Formula to count unique numbers in column
The following formula will count unique numbers in a column – it does not count text.
=SUM(IF(FREQUENCY(A2:A10,A2:A10)>0,1))