Subho Bijoya

ঢাকের উপর ছিল কাঠি,
পুজো হল জমজমাটি,
আজকে মায়ের ফেরার পালা
জানাই তাই এবেলা

শুভ বিজয়া

Counting unique values in Open Office

The spreadsheet program, Calc (equivalent of MS Excel) in Open Office does not have a function to count the number of unique numbers in a range. Here is a quick hack that I have been using for quite sometime for doing the same:

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

When using this hack, replace "Data" by the range of values from which you want the number of unique values like "A2:A10". This applies to Libre Office too, which is itself a fork of Open Office.

I would be very happy of Open Office or Libre Office developers took a note of this and implemented a simple COUNTUNIQUE(range) function in some next release.