Re: [office-comment] DISTINCT Values

From
Eike Rathke <>
Date
2007-06-08T16:39:34+00:00
ID
Thread
Re: [office-comment] DISTINCT Values
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