Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting
I have a worksheet with a column of names. Some names are listed many times
and some just once. I need to count each name just one time. Is there a function for this? -- Punkster |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting
One fast way - create a pivot with the col header placed in both the ROW and
DATA areas. The pivot will return both the list of unique names (that you seek) & the corresponding counts -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "punkster" wrote: I have a worksheet with a column of names. Some names are listed many times and some just once. I need to count each name just one time. Is there a function for this? -- Punkster |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting
Do you have a list of names already? If not, you can extract them with
Data/Filter/Advanced Filter (select Copy to Another Location, select your list as the List Range, select a Copy to location for the resulting list, and check Unique Records Only) Once the names are listed, use this function to count them (pretending that the list is in B3:B500 and the name to find is in D3): =COUNTIF($B$3:$B$500,D3) On May 12, 5:21 pm, punkster wrote: I have a worksheet with a column of names. Some names are listed many times and some just once. I need to count each name just one time. Is there a function for this? -- Punkster |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting
Max: I'm afraid I don't know how to create or use a pivot table. Is there
an easy way to tell me what to do? Reitanos: This works but just for one name at a time. This table has 3838 rows with probably 100 people. Can it be changed to count all the unique names? Thank you for your help. -- Punkster "Max" wrote: One fast way - create a pivot with the col header placed in both the ROW and DATA areas. The pivot will return both the list of unique names (that you seek) & the corresponding counts -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "punkster" wrote: I have a worksheet with a column of names. Some names are listed many times and some just once. I need to count each name just one time. Is there a function for this? -- Punkster |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting
"punkster" wrote:
Max: I'm afraid I don't know how to create or use a pivot table. Is there an easy way to tell me what to do? Some easy steps to lead you in (xl2003) Suppose the col header for the names col is: xxx Select the col, click Data Pivot table Click Next Next In step 3, click Layout Drag n drop "xxx" in ROW area Drag n drop "xxx" in DATA area (it'll appear as "Count of xxx") Click OK Finish. That's it! Hop over to the pivot sheet (just to the left) where you'd find both the list of unique names (that you seek) & the corresponding counts. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting function but not double counting duplicates | Excel Worksheet Functions | |||
Counting | Excel Worksheet Functions | |||
counting | Excel Discussion (Misc queries) | |||
Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
Counting names in a column but counting duplicate names once | Excel Discussion (Misc queries) |