On 3 February 2010 14:32, Andy Chaplin <perfect-engl...@gmx.de> wrote:
> If there a simple way to count the number of different values in a range? > > If I have a column with a thousand rows and I have different values in > the rows (some of which are repeated)... > > Bacon > Eggs > Toast > Marmalade > Toast > Toast > Bacon > > > The answer I want here is 4. (the total of different entries) > > I guess there must be a function for this, but I can's seem to find it. > > Any help would be appreciated. > > > > Assuming these are in a column in Calc, in rows 1 .. 1000. One way. There may be others: 1. Copy the data to a new column. 2. Sort the new column with the "delete duplicates" option 3. Look at the row number of the last entry -- Harold Fuchs London, England Please reply *only* to users@openoffice.org