Calc
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]
- Project Homepage [EN]
Documentation
- Shortcuts [EN]
Examples
- Counting unique values
Replace DATA with the corresponding data range e.g. A1:A100
=SUMPRODUCT((DATA<>"")/(COUNTIF(DATA;DATA)+(DATA="")))