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