Excel 2013 – Formula to count unique numbers in column

Friday, 8 May 2015 by Adrian Gordon

Last updated: Saturday, 27 May 2023

The following formula will count unique numbers in a column – it does not count text.

=SUM(IF(FREQUENCY(A2:A10,A2:A10)>0,1))