counting names

[the counter person@discussions.microsoft.com behind the counter person]

I am trying to count the number of times all names in a list are listed. I
have 1200 names and many are listed many times. I need to find out the
number of times the names occur. I am using Excel 2003 Any help?

[Pete_UK]

Do you already have a list of 1200 names? If not, it is easy to
generate them from your list containing duplicates. Highlight this
list (assume it is in column C) and include a header, then copy it to
a new sheet in column A. With the data still highlighted, click on
Data | Filter | Advanced Filter, and in the pop-up you should check
Unique Records only, check Copy to Another Location, and specify C1 as
the destination. Click OK and you will have your unique list in column
C, with your header in C1 - you can delete columns A and B.

Now in the new column B enter this formula:

=COUNTIF(Sheet1!C:C,A2)

assuming that your names are in column C of the original sheet -
adjust as necessary. Copy this formula down to cover your 1200 unique
names, and yo uwill have a count of each of them.

Hope this helps.

Pete

On Mar 26, 12:25 am, behind the counter person <behind the counter

[Ron Rosenfeld]

You could use a Pivot Table to generate a count of each name. Drag the Name
field to the Row area, and then drag the Name field to the Data (or Values)
area. If necessary change the Field Setting to Count.
--ron