Thread
:
Count Unique Numbers
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove
external usenet poster
Posts: 733
Count Unique Numbers
"T. Valko" wrote...
Here's another one:
=SUM(--(FREQUENCY(A2:A10,A2:A10)0))
....
Or just
=COUNT(1/FREQUENCY(A2:A10,A2:A10))
Reply With Quote
Harlan Grove
View Public Profile
Find all posts by Harlan Grove