Counting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

punkster - 12 May 2008 22:21 GMT

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?

Signature

Punkster

Reply to this Message

Max - 12 May 2008 22:29 GMT

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

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> 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?

Reply to this Message

punkster - 13 May 2008 15:20 GMT

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.

Signature

Punkster

> 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
> > 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?

Reply to this Message

Max - 13 May 2008 16:14 GMT

> 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.

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Reply to this Message

Reitanos - 12 May 2008 22:43 GMT

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 <punks...@discussions.microsoft.com>
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

Reply to this Message