Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.

# Ms Excel 2000 - Calculate Amount Of Times Names Appear On A List?

3 replies to this topic

### #1 alexcraw

alexcraw

• Members
• 40 posts
• OFFLINE
•
• Local time:12:51 AM

Posted 15 July 2008 - 02:50 PM

I need to take a list of names from a worksheet and assess how many times each person appears on it. This is a long list with duplicate names down the same column.

It sounds easy enough but I just can't find out how to do it.

Edited by alexcraw, 15 July 2008 - 03:39 PM.

### #2 tos226

tos226

BleepIN--BleepOUT

• Members
• 1,588 posts
• OFFLINE
•
• Gender:Female
• Location:LocalHost
• Local time:12:51 AM

Posted 15 July 2008 - 06:55 PM

Not much information to go on in your post.
So I'm guessing as follows:
You have a worksheet. In that worksheet JOHN appears x number of times, TERRY appears y number of times, is that guess about right?
All the names are in one column. Is that right?
If not, you have to provide more description.

If yes, a filter can help a lot without any fancy formulas.
Click Data, then Fileter, then AutoFilter on the column heading
[I assume you have a column headning such as Name above all the data]
Filter for the name on the dropdown list
Now look on the status line at the bottom.
Do you see a count?
If not, right click it, and select count.
It'll tell you how many.

If you can't use the filter, and must have a formula, assuming your names are in column A, the counting formula will be
=COUNTIF(A2:A11,"John")
where A2 to A11 is the range where the names occur

### #3 alexcraw

alexcraw
• Topic Starter

• Members
• 40 posts
• OFFLINE
•
• Local time:12:51 AM

Posted 15 July 2008 - 07:05 PM

That's just what I was after.

I knew how to use the autofilter, but the COUNTIF statement was definitley the thing I needed.

Many thanks

You are too kind.

### #4 tos226

tos226

BleepIN--BleepOUT

• Members
• 1,588 posts
• OFFLINE
•
• Gender:Female
• Location:LocalHost
• Local time:12:51 AM

Posted 15 July 2008 - 07:26 PM

Whoooopeee! Great. Thanks for the feedback.

#### 0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users