2010/2/3 Andy Chaplin <perfect-engl...@gmx.de>: > Ledger Consulting wrote: >> If I understand your question, you can use the =count() formula. You >> can also right click on "sum" at the bottom of your screen and select >> count. This will give you a count of the total values that you >> highlight. This works with numbers in a row, but not with words. >> > > Using Count on the example below returns 0, not 4 > > The method which Harold suggested below works. I had just hoped that > there was a more elegant way of doing it. > > Thanks anyway. if anyone knows of a formula, I'd be glad to hear of it.
You can always write your own formula, if you have some programming skills. Regards Johnny Rosenberg > > > > >> On 2/3/2010 8:37 AM, Harold Fuchs wrote: >> >> 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 >> >> >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: users-unsubscr...@openoffice.org >> For additional commands, e-mail: users-h...@openoffice.org >> > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@openoffice.org > For additional commands, e-mail: users-h...@openoffice.org > > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org