Thread: Count Unique Numbers
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove Harlan Grove is offline
external usenet poster
  
Posts: 733
Default 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 QuoteReply With Quote