Results 1 to 2 of 2

Concatenate text strings from column using multiple criteria condition (formula)

Threaded View

  1. #1
    Registered User
    Join Date
    12-13-2012
    Location
    Here and There
    MS-Off Ver
    Office 365 Home (Mac and Windows)
    Posts
    4

    Question Concatenate text strings from column using multiple criteria condition (formula)

    Hi!

    I am looking for a way of creating the following conditioned concatenation, and was looking for help here.

    I have two tables, let's call them "summary" and "detailed".

    The "detailed" table is something like the following:

    ID VOL
    001 01
    001 05
    002 04
    002 01
    001 03
    003 06


    The "summary" table below gets info from the "detailed" table. The 'ID'is now unique. I'm looking for a formula on the 'VOL (concatenated)' column cells it should get all rows from the "detailed" table with the same ID and then concatenate the 'VOL' column results, comma separated:


    ID (unique) VOL (concatenated)
    001 V01, V03, V05
    002 V01, V04
    003 V06

    Thanks very much in advance for your help.

    PS: I have people using this table with office 2003, so compatibility is necessary... :S

    (edit) PS2: this probably should be place on the formulas subforum, sorry about that. :S
    Last edited by se7en___; 12-20-2012 at 04:09 PM. Reason: added ps2, request to move

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