You don't even need a formula for this one. Just a Pivot table.

See:

http://peltiertech.com/Excel/Pivots/pivotstart.htm

for example if column A had:

Animal
mouse
mouse
cat
cat
cat
dog
cat
cat
cat
cat
dog
dog

the the pivot table would be:

Count of Animal
Animal Total
cat 7
dog 3
mouse 2
Grand Total 12

--
Gary''s Student - gsnu200746


"Popey" wrote:

Hi

Here's one for you Excel forumla wizards:

Using Excel 2007 -

I have a list of customer names in Column C of a customer database I have
created, some names are repeated as they are frequent customers. Is there a
(hopefully simple) formula that would automatically search column C and tell
me how many times each customer has appeared in that column, thereby allowing
me to readily see which customers return the most?

Very many thanks.