Calc

From RaySoft

Calc is the spreadsheet program you've always wanted. Newcomers find it intuitive and easy to learn; professional data miners and number crunchers will appreciate the comprehensive range of advanced functions.[1]

Documentation

Examples

Counting unique values

Replace DATA with the corresponding data range e.g. A1:A100

=SUMPRODUCT((DATA<>"")/(COUNTIF(DATA;DATA)+(DATA="")))

References