Hi Leonard,
On Friday, 2007-06-08 00:19:35 +0300, Leonard Mada wrote:
> I strongly miss a function to return the number of DISTINCT values
> existent in a given cell range. To my knowledge, this functionality is
> missing in every spreadsheet application, although most of the research
> involves such analysis.
Usually spreadsheet applications offer this with the filter
functionality as an option to write the result to a different output
location (cell range / sheet) and not include duplicates. That data then
can be further processed.
Eike
--
OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS