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. > 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]
