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:
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.
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.
This is interesting.
ReplyDeleteIs there any formula to print number in words inside a cell in OpenOffice or Office?
This is interesting.
ReplyDeleteIs there any formula to print number,say 10, in words, like ten, in openoffice or ms-office