On 2/3/2010 9:32 AM, Andy Chaplin 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.
Andy:
Try using this tip I found for Excel. I corrected the syntax for Calc
and it works.
(Note: ColRange is the column range of the data you want to count.)
=sum(1/countif(ColRange;ColRange)) , then use ctrl-shift enter instead
of just enter.
This enters it as an array formula
TomW
