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.
You can use a three-step process starting with a standard filter. Put a
title, say Food, above the column of foods that you want to evaluate.
Select the title and all of the foods in the column. Then under Data
select Filter and Standard Filter. The Filter criteria will list Field
Name as Food. Make the condition '>' and the Value "", where '>' has no
quotes around it and "" indicates "nothing". Then select More. Check
or click "No duplication" and "Copy results to...". Chose a first cell
where you want the unique list of foods to be stored. Then click "OK".
You will now have a unique list of foods from your larger list. Go to
an empty cell and select the =counta() function. Choose the cell-range
of the unique foods as the argument for the function. The result is the
number of foods in your unique list of foods.
Food Food
Bacon Bacon
Eggs Eggs
Toast Toast
Marmalade Marmalade
Toast
Toast 4
Bacon
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
