Count unique values in OpenOffice.org CalcPosted: December 4, 2011
It may seem strange, but the OpenOffice spreadsheet Calc is missing a much needed ability to count how many unique values are there in the certain range of cells.
Luckily there are people who know how to fill in the gap, so here it is. A quick and simple method. Copy the formula below and paste it into your spreadsheet replacing the sample data range F2:F10 with the one you actually need.