+ Reply to Thread
Results 1 to 6 of 6

How to concatenate repeated values per row without duplicates

  1. #1
    Registered User
    Join Date
    10-09-2019
    Location
    Austin, Texas
    MS-Off Ver
    16.29.1 Excel for Mac
    Posts
    3

    How to concatenate repeated values per row without duplicates

    I'm working with a dataset that is categorizing multiple variables from a 0-1 basis, thus assigning them as 1-5 (out of 13), and am trying to concatenate these without duplicates to see which are applicable per record id. I am driving myself mad trying to figure this out and am hoping that a formula would work vs. code for the basic need. Or if there is a better way of combining/assessing? Please to help! It won't let me upload a file, so I'm working on that, but can send if you would like. Thanks so much!


    This is horrendous, sorry!

    ADMINISTRATION
    14/7 14.1 Please specify:
    ID G_CARE_STUDENT1 G_CARE_T_STAFF2 G_CARE_CUST_STAFF2 G_CARE_OTHER_STAFF2 G_CARE_GC4 G_CARE_PTA_VOL5 G_CARE_PTA_VOL5 G_CARE_P_VOL5 G_CARE_GCOMM4 G_CARE_AFTSCH1 G_CARE_PARTNER_ORG3 G_CARE_COMM_VOL5 G_CARE_NPR_ORG3 G_CARE_FREQ
    1 2 2 2 4 5 5 5 4 1 3 5 3 108,104,18,41,24,27,28,56,63,47,20,41,24, CONCATENATE formaula for sums N4
    1=CLASSES carried through for represented values in each column, but has duplicates -how do I get have a set from 1-5? represented per record Id#?
    NOTE: #4 INCLUDES VOL GC 2=STAFF/DISTRICT
    3=OUTSIDE ORGS (SPROUTS, 4H, UNITED WAY)
    4=COORDINATOR/COMITTEE
    108 104 18 41 24 27 28 56 63 47 20 41 24 5=VOLUNTEER
    8 1 2 0 0 0 0 0 0 0 0 0 0 0 1,2,0,0,0,0,0,0,0,0,0,0,0,
    11 1 2 0 0 0 0 0 0 0 1 0 0 0 1,2,0,0,0,0,0,0,0,1,0,0,0,
    12 1 2 0 0 0 0 0 5 0 0 3 5 0 1,2,0,0,0,0,0,5,0,0,3,5,0,
    13 1 2 0 0 0 0 0 0 0 0 3 5 0 1,2,0,0,0,0,0,0,0,0,3,5,0,
    28 0 0 0 0 0 0 0 0 0 4 0 0 0 0,0,0,0,0,0,0,0,0,4,0,0,0,
    29 0 0 2 0 0 0 0 0 0 0 0 0 0 0,0,2,0,0,0,0,0,0,0,0,0,0,
    30 1 2 0 0 0 0 0 0 4 0 0 0 0 1,2,0,0,0,0,0,0,4,0,0,0,0,
    36 0 0 0 0 0 0 0 0 0 0 0 5 0 0,0,0,0,0,0,0,0,0,0,0,5,0,
    42 0 0 0 0 0 0 0 0 0 0 0 0 0 0,0,0,0,0,0,0,0,0,0,0,0,0,
    44 0 0 0 0 0 0 0 0 4 0 0 0 0 0,0,0,0,0,0,0,0,4,0,0,0,0,
    45 1 2 0 0 0 0 0 5 0 0 0 5 0 1,2,0,0,0,0,0,5,0,0,0,5,0,
    46 1 0 0 0 0 5 5 0 0 0 0 0 0 1,0,0,0,0,5,5,0,0,0,0,0,0,
    47 0 0 0 0 0 0 0 5 0 0 0 0 0 0,0,0,0,0,0,0,5,0,0,0,0,0,
    74 1 2 0 0 0 0 0 0 0 0 0 0 0 1,2,0,0,0,0,0,0,0,0,0,0,0,
    79 1 0 0 0 0 0 0 0 0 0 0 0 0 1,0,0,0,0,0,0,0,0,0,0,0,0,
    90 0 2 0 0 0 0 0 0 4 0 0 0 0 0,2,0,0,0,0,0,0,4,0,0,0,0,
    92 1 2 0 0 0 0 0 0 0 0 0 5 0 1,2,0,0,0,0,0,0,0,0,0,5,0,
    102 0 2 2 0 0 0 0 0 0 0 0 5 0 0,2,2,0,0,0,0,0,0,0,0,5,0,
    108 1 2 0 0 0 0 0 5 0 0 0 0 0 1,2,0,0,0,0,0,5,0,0,0,0,0,
    135 0 0 0 0 0 0 0 0 4 1 0 0 0 0,0,0,0,0,0,0,0,4,1,0,0,0,
    137 1 2 0 0 0 0 0 0 4 0 0 5 0 1,2,0,0,0,0,0,0,4,0,0,5,0,
    158 1 0 0 0 0 0 0 0 0 1 0 0 0 1,0,0,0,0,0,0,0,0,1,0,0,0,
    177 1 2 0 2 0 0 0 0 0 0 0 0 0 1,2,0,2,0,0,0,0,0,0,0,0,0,
    189 1 2 0 0 4 0 0 0 4 0 0 0 0 1,2,0,0,4,0,0,0,4,0,0,0,0,
    190 1 2 0 0 0 0 0 5 4 1 0 0 0 1,2,0,0,0,0,0,5,4,1,0,0,0,
    215 1 2 0 2 4 0 0 0 0 0 0 0 0 1,2,0,2,4,0,0,0,0,0,0,0,0,
    229 0 2 2 2 0 0 0 0 0 0 0 0 0 0,2,2,2,0,0,0,0,0,0,0,0,0,
    230 0 2 0 0 0 0 0 0 0 0 0 0 0 0,2,0,0,0,0,0,0,0,0,0,0,0,
    238 1 2 0 0 0 5 5 0 0 0 0 5 0 1,2,0,0,0,5,5,0,0,0,0,5,0,
    254 1 2 0 2 0 0 0 5 4 1 0 5 0 1,2,0,2,0,0,0,5,4,1,0,5,0,
    258 1 2 0 0 0 0 0 5 4 0 0 0 0 1,2,0,0,0,0,0,5,4,0,0,0,0,
    259 1 2 0 0 0 0 0 5 4 0 0 0 3 1,2,0,0,0,0,0,5,4,0,0,0,3,
    286 1 2 0 2 0 0 0 5 0 0 0 0 0 1,2,0,2,0,0,0,5,0,0,0,0,0,
    291 0 0 0 0 0 0 0 0 0 0 0 0 3 0,0,0,0,0,0,0,0,0,0,0,0,3,
    292 1 0 0 2 0 0 0 0 0 1 0 0 0 1,0,0,2,0,0,0,0,0,1,0,0,0,
    293 0 0 0 0 0 0 0 0 0 1 0 0 0 0,0,0,0,0,0,0,0,0,1,0,0,0,
    309 1 2 0 2 0 0 0 5 4 0 0 0 0 1,2,0,2,0,0,0,5,4,0,0,0,0,
    310 1 2 0 0 0 5 5 5 4 0 0 0 0 1,2,0,0,0,5,5,5,4,0,0,0,0,
    363 1 0 0 0 0 0 0 5 4 0 0 0 0 1,0,0,0,0,0,0,5,4,0,0,0,0,
    369 1 2 0 0 0 0 0 0 0 1 0 5 3 1,2,0,0,0,0,0,0,0,1,0,5,3,
    380 1 2 2 0 0 0 0 5 4 1 0 5 0 1,2,2,0,0,0,0,5,4,1,0,5,0,
    383 1 2 0 0 0 5 5 5 0 0 0 0 0 1,2,0,0,0,5,5,5,0,0,0,0,0,
    389 1 2 0 0 0 0 0 0 0 0 0 5 3 1,2,0,0,0,0,0,0,0,0,0,5,3,
    390 1 2 0 0 0 5 5 0 0 0 0 0 0 1,2,0,0,0,5,5,0,0,0,0,0,0,
    405 0 0 0 2 0 0 0 0 4 0 0 0 3 0,0,0,2,0,0,0,0,4,0,0,0,3,
    415 0 0 0 0 0 0 0 5 4 0 0 0 0 0,0,0,0,0,0,0,5,4,0,0,0,0,
    423 0 2 0 2 0 0 0 0 0 0 0 0 0 0,2,0,2,0,0,0,0,0,0,0,0,0,
    436 1 2 0 2 0 0 0 0 0 1 0 0 0 1,2,0,2,0,0,0,0,0,1,0,0,0,
    437 0 0 0 2 0 0 0 0 0 1 0 0 3 0,0,0,2,0,0,0,0,0,1,0,0,3,
    447 1 2 0 0 4 0 0 0 0 1 0 0 0 1,2,0,0,4,0,0,0,0,1,0,0,0,
    449 0 2 0 0 4 0 0 0 0 1 0 0 0 0,2,0,0,4,0,0,0,0,1,0,0,0,
    459 1 2 0 0 0 0 0 0 4 1 0 0 0 1,2,0,0,0,0,0,0,4,1,0,0,0,
    493 1 2 0 0 0 0 0 0 4 0 3 0 0 1,2,0,0,0,0,0,0,4,0,3,0,0,
    495 1 2 0 0 0 0 0 5 0 0 3 0 0 1,2,0,0,0,0,0,5,0,0,3,0,0,
    513 1 2 0 2 0 0 0 5 0 0 0 5 0 1,2,0,2,0,0,0,5,0,0,0,5,0,
    517 1 2 2 2 0 5 5 5 4 0 0 0 0 1,2,2,2,0,5,5,5,4,0,0,0,0,
    523 1 2 0 0 0 0 0 0 0 1 3 0 3 1,2,0,0,0,0,0,0,0,1,3,0,3,
    528 1 2 2 0 0 0 0 0 0 0 0 5 0 1,2,2,0,0,0,0,0,0,0,0,5,0,
    540 1 2 0 2 4 5 5 5 4 0 0 5 3 1,2,0,2,4,5,5,5,4,0,0,5,3,
    545 1 2 2 2 0 0 0 5 4 1 3 5 0 1,2,2,2,0,0,0,5,4,1,3,5,0,
    580 1 2 2 0 0 0 0 0 0 0 0 0 0 1,2,2,0,0,0,0,0,0,0,0,0,0,
    583 1 2 2 2 0 0 0 5 4 1 0 0 0 1,2,2,2,0,0,0,5,4,1,0,0,0,
    598 1 0 0 0 0 5 5 5 4 0 0 0 0 1,0,0,0,0,5,5,5,4,0,0,0,0,
    624 1 2 0 0 0 5 5 5 4 1 0 0 0 1,2,0,0,0,5,5,5,4,1,0,0,0,
    627 1 2 0 2 0 0 0 0 4 0 0 0 0 1,2,0,2,0,0,0,0,4,0,0,0,0,
    631 1 0 0 0 0 0 0 0 4 1 0 0 0 1,0,0,0,0,0,0,0,4,1,0,0,0,
    643 0 2 0 0 4 0 0 0 4 0 0 0 0 0,2,0,0,4,0,0,0,4,0,0,0,0,
    665 0 0 0 0 4 0 0 0 0 0 0 0 0 0,0,0,0,4,0,0,0,0,0,0,0,0,
    671 1 2 0 0 4 0 0 5 4 0 0 0 0 1,2,0,0,4,0,0,5,4,0,0,0,0,
    677 0 2 0 0 0 0 0 5 0 0 0 0 0 0,2,0,0,0,0,0,5,0,0,0,0,0,
    684 1 2 0 0 0 0 0 0 0 0 3 0 0 1,2,0,0,0,0,0,0,0,0,3,0,0,
    694 1 2 2 2 0 0 0 0 0 1 0 0 0 1,2,2,2,0,0,0,0,0,1,0,0,0,
    707 1 2 0 0 4 0 0 0 0 1 0 5 0 1,2,0,0,4,0,0,0,0,1,0,5,0,
    710 1 2 0 2 0 0 0 0 4 0 0 5 0 1,2,0,2,0,0,0,0,4,0,0,5,0,
    727 1 2 0 2 0 5 5 5 4 0 0 0 0 1,2,0,2,0,5,5,5,4,0,0,0,0,
    739 0 0 0 2 0 0 0 0 0 1 0 0 0 0,0,0,2,0,0,0,0,0,1,0,0,0,
    742 1 2 0 0 4 0 0 5 0 0 0 0 0 1,2,0,0,4,0,0,5,0,0,0,0,0,
    743 1 0 0 0 4 0 0 0 0 1 0 0 0 1,0,0,0,4,0,0,0,0,1,0,0,0,
    746 1 0 0 0 0 0 0 0 4 0 0 0 0 1,0,0,0,0,0,0,0,4,0,0,0,0,
    747 0 0 0 0 0 0 0 5 4 1 0 5 0 0,0,0,0,0,0,0,5,4,1,0,5,0,
    210 1 2 2 0 0 0 0 0 0 0 3 5 0 1,2,2,0,0,0,0,0,0,0,3,5,0,
    441 1 0 0 0 0 0 0 0 0 0 0 0 3 1,0,0,0,0,0,0,0,0,0,0,0,3,
    392 1 2 2 2 0 0 0 0 4 1 0 0 0 1,2,2,2,0,0,0,0,4,1,0,0,0,
    320 0 0 0 2 0 0 0 0 0 0 0 0 0 0,0,0,2,0,0,0,0,0,0,0,0,0,
    322 0 2 0 0 0 0 0 0 0 1 0 0 0 0,2,0,0,0,0,0,0,0,1,0,0,0,
    327 1 2 2 2 0 5 5 0 0 0 0 0 0 1,2,2,2,0,5,5,0,0,0,0,0,0,
    332 1 2 2 2 0 0 0 0 0 0 0 0 0 1,2,2,2,0,0,0,0,0,0,0,0,0,
    492 1 2 0 0 4 0 0 0 0 0 0 0 0 1,2,0,0,4,0,0,0,0,0,0,0,0,
    500 1 2 0 2 0 0 0 5 4 0 0 5 0 1,2,0,2,0,0,0,5,4,0,0,5,0,
    502 0 2 0 2 0 0 0 5 0 0 0 0 0 0,2,0,2,0,0,0,5,0,0,0,0,0,
    503 0 2 0 0 0 5 5 0 0 0 0 0 0 0,2,0,0,0,5,5,0,0,0,0,0,0,
    520 1 0 0 0 0 0 0 5 4 0 0 5 0 1,0,0,0,0,0,0,5,4,0,0,5,0,
    526 0 2 2 0 0 0 0 0 4 1 3 0 3 0,2,2,0,0,0,0,0,4,1,3,0,3,
    527 1 2 0 0 0 0 0 0 0 0 3 0 3 1,2,0,0,0,0,0,0,0,0,3,0,3,
    538 1 2 0 0 0 0 0 0 4 0 3 0 3 1,2,0,0,0,0,0,0,4,0,3,0,3,
    549 1 2 0 0 0 0 0 5 4 0 0 5 0 1,2,0,0,0,0,0,5,4,0,0,5,0,
    558 1 2 0 0 4 0 0 5 4 0 0 5 0 1,2,0,0,4,0,0,5,4,0,0,5,0,
    576 1 2 0 0 4 0 0 5 0 1 0 0 0 1,2,0,0,4,0,0,5,0,1,0,0,0,
    628 1 2 0 0 0 0 0 5 0 1 0 0 0 1,2,0,0,0,0,0,5,0,1,0,0,0,
    709 1 2 0 2 0 0 0 0 4 1 0 0 0 1,2,0,2,0,0,0,0,4,1,0,0,0,
    731 0 0 0 0 0 5 5 0 0 0 0 0 0 0,0,0,0,0,5,5,0,0,0,0,0,0,
    278 1 2 0 0 0 0 0 0 0 1 0 0 3 1,2,0,0,0,0,0,0,0,1,0,0,3,
    282 1 2 0 2 0 0 0 5 4 0 3 0 0 1,2,0,2,0,0,0,5,4,0,3,0,0,
    232 1 2 0 0 0 0 0 0 0 0 0 0 3 1,2,0,0,0,0,0,0,0,0,0,0,3,
    233 1 2 0 0 0 0 0 5 0 0 0 5 3 1,2,0,0,0,0,0,5,0,0,0,5,3,
    240 0 0 0 0 0 0 0 0 0 0 3 0 0 0,0,0,0,0,0,0,0,0,0,3,0,0,
    241 0 0 0 0 0 0 0 0 0 0 3 0 3 0,0,0,0,0,0,0,0,0,0,3,0,3,
    481 1 0 0 0 0 0 0 0 4 0 0 0 3 1,0,0,0,0,0,0,0,4,0,0,0,3,
    255 1 2 0 2 0 5 5 5 4 1 3 5 0 1,2,0,2,0,5,5,5,4,1,3,5,0,
    209 1 2 0 2 0 0 0 0 0 0 0 5 0 1,2,0,2,0,0,0,0,0,0,0,5,0,
    728 1 0 0 0 0 5 5 0 4 0 0 0 0 1,0,0,0,0,5,5,0,4,0,0,0,0,
    410 0 2 0 0 0 0 0 5 4 1 3 5 0 0,2,0,0,0,0,0,5,4,1,3,5,0,
    347 1 0 0 0 0 0 0 0 4 1 0 5 0 1,0,0,0,0,0,0,0,4,1,0,5,0,
    636 1 2 0 2 0 0 0 0 4 0 3 0 0 1,2,0,2,0,0,0,0,4,0,3,0,0,
    732 0 0 0 0 0 5 5 0 4 0 0 0 0 0,0,0,0,0,5,5,0,4,0,0,0,0,
    355 1 2 0 2 4 5 5 5 4 1 0 0 0 1,2,0,2,4,5,5,5,4,1,0,0,0,
    356 0 0 0 0 4 0 0 0 4 0 0 0 3 0,0,0,0,4,0,0,0,4,0,0,0,3,
    361 1 2 0 0 4 0 0 5 4 0 3 5 0 1,2,0,0,4,0,0,5,4,0,3,5,0,
    399 1 2 0 0 0 5 5 5 0 0 0 5 0 1,2,0,0,0,5,5,5,0,0,0,5,0,
    313 1 2 0 0 0 5 5 5 4 1 3 0 0 1,2,0,0,0,5,5,5,4,1,3,0,0,
    314 1 2 0 0 0 5 5 5 0 1 0 5 0 1,2,0,0,0,5,5,5,0,1,0,5,0,
    420 1 2 2 2 4 0 0 5 4 0 0 0 0 1,2,2,2,4,0,0,5,4,0,0,0,0,
    288 0 2 0 0 0 0 0 5 4 0 0 0 0 0,2,0,0,0,0,0,5,4,0,0,0,0,
    297 1 0 0 0 0 0 5 5 0 0 0 5 0 1,0,0,0,0,0,5,5,0,0,0,5,0,
    338 0 0 0 0 0 0 0 5 4 1 0 0 0 0,0,0,0,0,0,0,5,4,1,0,0,0,
    402 1 2 0 0 4 0 0 5 4 1 0 0 0 1,2,0,0,4,0,0,5,4,1,0,0,0,
    298 1 2 0 0 0 5 5 5 4 1 3 5 0 1,2,0,0,0,5,5,5,4,1,3,5,0,
    388 1 2 0 2 0 0 0 5 0 0 0 5 3 1,2,0,2,0,0,0,5,0,0,0,5,3,
    573 1 0 0 0 0 0 0 5 0 0 0 0 0 1,0,0,0,0,0,0,5,0,0,0,0,0,
    623 0 2 0 2 0 0 0 0 4 1 0 5 0 0,2,0,2,0,0,0,0,4,1,0,5,0,
    641 1 2 0 0 4 0 0 0 4 0 0 5 3 1,2,0,0,4,0,0,0,4,0,0,5,3,
    645 1 2 0 0 4 0 0 0 4 1 0 5 0 1,2,0,0,4,0,0,0,4,1,0,5,0,
    654 1 2 0 0 0 5 5 0 4 0 0 0 0 1,2,0,0,0,5,5,0,4,0,0,0,0,
    663 1 0 0 0 4 0 0 0 0 0 0 0 0 1,0,0,0,4,0,0,0,0,0,0,0,0,
    668 1 2 0 0 0 0 0 0 4 0 0 0 3 1,2,0,0,0,0,0,0,4,0,0,0,3,
    744 1 0 0 0 0 5 5 0 0 0 0 5 0 1,0,0,0,0,5,5,0,0,0,0,5,0,
    750 1 2 2 0 0 0 0 0 4 0 0 0 3 1,2,2,0,0,0,0,0,4,0,0,0,3,
    443 1 0 0 2 0 0 0 0 0 0 0 0 0 1,0,0,2,0,0,0,0,0,0,0,0,0,
    450 1 2 0 0 4 0 0 0 0 1 0 0 3 1,2,0,0,4,0,0,0,0,1,0,0,3,
    451 1 0 0 0 4 0 0 0 0 0 0 5 0 1,0,0,0,4,0,0,0,0,0,0,5,0,
    456 1 2 0 2 0 0 0 0 0 1 0 5 0 1,2,0,2,0,0,0,0,0,1,0,5,0,
    460 1 2 2 2 0 5 5 5 0 1 0 0 0 1,2,2,2,0,5,5,5,0,1,0,0,0,
    735 1 2 0 2 0 5 5 5 0 0 0 0 0 1,2,0,2,0,5,5,5,0,0,0,0,0,
    192 1 2 0 0 0 5 5 5 0 1 0 0 0 1,2,0,0,0,5,5,5,0,1,0,0,0,
    184 1 2 0 2 0 0 0 0 0 0 0 0 3 1,2,0,2,0,0,0,0,0,0,0,0,3,
    204 0 2 0 0 0 5 5 5 0 1 0 0 0 0,2,0,0,0,5,5,5,0,1,0,0,0,
    Last edited by a.hoover; 10-09-2019 at 08:01 PM.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: How to concatenate repeated values per row without duplicates

    You can upload a file, but not using the Paperclip icon (Attachments button) as it doesn't work on this forum.

    To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach (an Excel workbook), then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

    Hope this helps.

    Pete

  3. #3
    Forum Expert
    Join Date
    09-30-2019
    Location
    Chiangmai, Thailand
    MS-Off Ver
    Office 2016, Excel 2019
    Posts
    1,234

    Re: How to concatenate repeated values per row without duplicates

    Can you use TEXTJOIN function ?

    N4
    =TextJoin(",",True,B4:M4)

    This formula will join from G_CARE_STUDENT1 to G_CARE_FREQ (separated by , )

    But I'm still don't know after concatenat all columns, how to decided which is applicable.


    Regards.

  4. #4
    Registered User
    Join Date
    10-09-2019
    Location
    Austin, Texas
    MS-Off Ver
    16.29.1 Excel for Mac
    Posts
    3
    Thank you for the info!
    Quote Originally Posted by Pete_UK View Post
    You can upload a file, but not using the Paperclip icon (Attachments button) as it doesn't work on this forum.

    To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach (an Excel workbook), then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

    Hope this helps.

    Pete

  5. #5
    Registered User
    Join Date
    10-09-2019
    Location
    Austin, Texas
    MS-Off Ver
    16.29.1 Excel for Mac
    Posts
    3
    I thought so, but can't seem to get it together for the overall code without duplication. Does this work for that?
    Quote Originally Posted by menem View Post
    Can you use TEXTJOIN function ?

    N4
    =TextJoin(",",True,B4:M4)

    This formula will join from G_CARE_STUDENT1 to G_CARE_FREQ (separated by , )

    But I'm still don't know after concatenat all columns, how to decided which is applicable.


    Regards.

  6. #6
    Forum Expert
    Join Date
    09-30-2019
    Location
    Chiangmai, Thailand
    MS-Off Ver
    Office 2016, Excel 2019
    Posts
    1,234

    Re: How to concatenate repeated values per row without duplicates

    the overall code without duplication

    What dose it's mean?

    No duplication in each ID (single row)
    or
    No duplication in ALL ID (by remove 0 away) but still problem it's not refer to each field (column)


    It will be better if you can upload a sample file with sample desired output.

    Regards.

+ 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. Auto concatenate and reverse concatenate & Remove duplicates .
    By Andy308 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-15-2016, 12:38 PM
  2. [SOLVED] Check for duplicates against multiple criteria and then concatenate values
    By Pango in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-15-2016, 06:54 PM
  3. Replies: 1
    Last Post: 10-11-2014, 04:52 AM
  4. [SOLVED] Macro to find duplicates, concatenate Unique Values, then delete old duplicates
    By lesoies in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-17-2013, 04:32 PM
  5. Update to Macro to find duplicates, concatenate Unique Values
    By lesoies in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-10-2013, 06:35 PM
  6. Concatenate values from columns and deleting duplicates
    By RandomP in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-15-2011, 06:20 PM
  7. [SOLVED] Append data to repeated values with a fixed array to be repeated on value change
    By anchuri_chaitanya in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-06-2011, 12:30 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