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))

Excel-CountUniqueNumbers1

Was this article helpful?

Related Articles