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
- How to export Outlook auto-complete to Excel list
- 0
- Outlook 2013/2016 – Where is the auto-complete list stored?
- 0
- Microsoft Office version numbers
- 0
- Word 2013 – How to enable the page ruler
- 0
- Excel 2013/2016 – How to change CSV delimiter character
- 1
- Excel 2013/2016 – How to split comma separated values into columns
- -1