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))