Excel 2013 – Formula to count unique numbers in column Friday, 8 May 2015 by Adrian GordonLast updated: Friday, 8 May 2015 The following formula will count unique numbers in a column – it does not count text. =SUM(IF(FREQUENCY(A2:A10,A2:A10)>0,1)) Related Articles Excel – How to calculate days until, between or after dates Word 2016 – Fix random list items indented Word 2016 – How to change text case Word 2016 – How to show merge tags Word – Table won’t paste in new location 1 Word – how to mail merge many records to individual documents 5
