Hi Gary
Many thanks for the reply, but looking at the instructions for creating
pivot data, my brain exploded out of my ears - it looks very complicated.
All the instructions seem to be aimed at multiple columns of data. The
example you gave (animals) looks just what I am looking for, but I can't see
how it would be created.
"Gary''s Student" wrote:
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.