Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
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.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

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


  • Please log in to reply
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.

Any help you can give would be much appreciated.

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


BC AdBot (Login to Remove)

 


#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

:thumbsup:

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.

:flowers:

#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