Excel 97 counting instances.....

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

Not sure if this is easy to do or not.
I have an Excel Spreadsheet as follows.
Name
----
Bob
Fred
Bob
Charlie

Now I want to create in a seperate worksheet an alhpabetic
list of the names with a count against each one.

The list of names is random each time the spreadsheet is
opened so I can't create a formula where the name is known
in advance.
Any ideas? Is there a blatantly easy answer that I'm
missing?
Resulting worksheet will look like:
Name Count
---- -----
Bob 2
Charlie 1
Fred 1
 
You can create a pivot table to summarize the data, then refresh it if
the data changes:

1. Select a cell in the table
2. Choose Data>PivotTable and PivotChart report
3. Click Next, check the range, click Next
4. Click the Layout button
5. Drag the Name button to the Row area
6. Drag another copy of the Name button to the Data area,
where it will become Count of Name
7. Click OK, click Finish

If the data changes, click the Refresh button to update the PivotTable
 
Back
Top