Count distinct

[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!

 

[immanuel]

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.