Got it!
In 2007 there is no field called "Data". The four boxes are labelled
"Report Filter", "Row Labels", Column Labels", and "Values".
I tinkered with them going by your instructions and finally managed to
'translate' what you were syaing into 2007 language
Many thanks.
"Gary''s Student" wrote:
Let's walk thru it step-by-step:
1. highlight cells A1 thru A13 (my example)
2. pull-down:
Data PivotTable Next Next Layout
You will now see 4 panes: Page, Row, Column, and Data
Drag the Animal button into the Row pane and then also into the Data pane
(the Data pane will show: Count of Animal)
Then click OK
Then click Finish
Update this post if you experience any problems.
--
Gary''s Student - gsnu200746
"Popey" wrote:
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.