Excel 2013 – Formula to count unique numbers in column

by

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

Leave a Comment

Your email address will not be published. Required fields are marked *