Count distinct

  • Thread starter Thread starter John Chow
  • Start date Start date
J

John Chow

I used to count distinct numbers with the help of pivot table.
But would there be any easily formula / function key I can use instead ?

Thanks!
 
The most elegant method I've seen is the following array formula:

[=SUM(1/COUNTIF(range,range))]

where range is something like A1:A100.

Remember to Ctrl-Shift-Enter after punching it in the destination cell.

/i.
 
Back
Top