Results 1 to 5 of 5

Excel 2003 Counting how many data cells correspond to a specific cell (Person's Name)

Threaded View

  1. #1
    Registered User
    Join Date
    06-22-2012
    Location
    New Brunswick, NJ
    MS-Off Ver
    Excel 2003
    Posts
    53

    Excel 2003 Counting how many data cells correspond to a specific cell (Person's Name)

    I have two columns. Column A has a person's name and Column B has dated notes on that specific person, some names have more notes than others. I was wondering if there is a function similar to count that could see how many note cells associate with a specific name or if you can look up how many dates appear for a specific person, thus giving you the number of notes on them. Any help or advice is greatly appreciated I have a thousand names or so with notes I need to count. Example I attached to this post.

    Column1
    Name

    Durant, Kevin

    Column2
    Notes

    3/8/12-Met with Kevin talked about blah
    3/12/2012-Discussed procedures

    Column3

    Number of Notes
    2
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1