+ Reply to Thread
Results 1 to 3 of 3

Trying to create a Counter - to keep track automatically (VLOOKUP, FIND) help?

  1. #1
    Forum Contributor
    Join Date
    09-23-2015
    Location
    Toronto, Ontario
    MS-Off Ver
    Excel 2010
    Posts
    187

    Trying to create a Counter - to keep track automatically (VLOOKUP, FIND) help?

    Hi fabulous Excel gurus,


    I made a sample spreadsheet for you guys to display my problem.

    BACKGROUND:

    I have a spreadsheet where we keep track of meetings done with counter parties. As more meetings happen, more data will be enter. Right now I put sample data in the first two counter parties, but in reality we have done meetings with them all and data will be in each.

    WHAT IM TRYING TO DO:

    I am trying to get the top part A4:J12 to keep track of the the meetings each person has been attending. The formula in my mind would have to look up if the Employee's name is in Firm Attendance under each of the counter parties....


    PROBLEM:

    Do to the various lookup ranges for Firm Attendance, and incorporating a counter to count, and the fact that all the names are stored in a single cell rather than there own, I am totally lost on how to do this....

    FYI - If it is impossible to look up a single name in a cell containing multiple names like this below

    Jacob Smith
    John Doe
    Henry Henricks
    Dustin Katz

    Than what do you suggest I do?


    Any help out there?
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: Trying to create a Counter - to keep track automatically (VLOOKUP, FIND) help?

    In B5 copied across and down

    =COUNTIF(OFFSET($A$15,1,MATCH($A5, $15:$15,0)+2,50,1),"*"&B$4 &"*")
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Forum Contributor
    Join Date
    09-23-2015
    Location
    Toronto, Ontario
    MS-Off Ver
    Excel 2010
    Posts
    187

    Re: Trying to create a Counter - to keep track automatically (VLOOKUP, FIND) help?

    Quote Originally Posted by ChemistB View Post
    In B5 copied across and down

    =COUNTIF(OFFSET($A$15,1,MATCH($A5, $15:$15,0)+2,50,1),"*"&B$4 &"*")
    You sir are a seriously nice human, not all heroes wear capes

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Create a tally counter
    By jnynewart in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 03-25-2016, 08:19 PM
  2. how to create a counter
    By Daanish in forum Excel General
    Replies: 3
    Last Post: 08-31-2010, 02:03 PM
  3. How do I create a counter?
    By AG in forum Excel General
    Replies: 1
    Last Post: 05-24-2006, 09:40 AM
  4. create a counter
    By sjl in forum Excel General
    Replies: 1
    Last Post: 04-26-2006, 08:35 AM
  5. How do I create an equivalent VLOOKUP function using FIND?
    By dan in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 PM
  6. How do I create an equivalent VLOOKUP function using FIND?
    By Bob Phillips in forum Excel Formulas & Functions
    Replies: 35
    Last Post: 09-06-2005, 05:05 PM
  7. How do I create an equivalent VLOOKUP function using FIND?
    By dan in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  8. Haw can I to create the numeric counter?
    By frenic in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-21-2005, 07:06 AM

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