+ Reply to Thread
Results 1 to 2 of 2

Conditional Concatenate a la Count Ifs

  1. #1
    Registered User
    Join Date
    08-17-2010
    Location
    NL
    MS-Off Ver
    Excel 2003
    Posts
    3

    Post Conditional Concatenate a la Count Ifs

    Hello,

    I have a tricky problem that I cannot fugired out. I have searched many excel forums but none of the suggestion seem to work for me.

    See the attachment:
    I have a table with an identifier in A, a Target in B, and Visit dates in C and D.
    Please Login or Register  to view this content.
    In my second table I want to list all visited Targets as a concat in one cell, when the visit matches the Identifier, and is within a defined time period. I need the list in one cell, because I want to mailmerge the data later.
    Please Login or Register  to view this content.
    So in essence, it works like a count ifs, but instead of counting, it should list the values, preferably with a "," in between.

    Can you help me make this work, using VBA code or a UDF?

    Thank you very much!

    Rigano
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,607

    Re: Conditional Concatenate a la Count Ifs

    Here is a custom function, e.g.

    =ListT(G3,$A$2:$D$20,1)
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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