Johnny Rosenberg wrote: > 2010/2/3 Andy Chaplin <[email protected]>: > >> 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 > > >
Thanks. I just might try that! >> >> >> >>> On 2/3/2010 8:37 AM, Harold Fuchs wrote: >>> >>> On 3 February 2010 14:32, Andy Chaplin<[email protected]> 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: [email protected] >>> For additional commands, e-mail: [email protected] >>> >>> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [email protected] >> For additional commands, e-mail: [email protected] >> >> >> > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
