Counting

  • Thread starter Thread starter punkster
  • Start date Start date
P

punkster

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?
 
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
 
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)
 
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 said:
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?
Click to expand...

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.

---
 
Back
Top