Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting names
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting names
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 wrote: 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting names
On Tue, 25 Mar 2008 17:25:02 -0700, behind the counter person <behind the
counter wrote: 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? 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting names | Excel Discussion (Misc queries) | |||
counting of names | Excel Discussion (Misc queries) | |||
counting names | Excel Worksheet Functions | |||
Counting Names in a List | Excel Discussion (Misc queries) | |||
Counting names in a column but counting duplicate names once | Excel Discussion (Misc queries) |