Results 1 to 2 of 2

Thread: Concatenating array into cells based on conditions

  1. #1
    Junior Member
    Join Date
    Dec 2012
    Posts
    1
    Rep Power
    0

    Question Concatenating array into cells based on conditions

    Am looking for help creating the output below in Excel 2007. I have a large number of data points; the example is a subset for discussion purposes.

    For each row in the table on the left, output an "x" (or other character) to the corresponding cell in a new array (shown on the right), concatenating and separating by commas, if there is more than one row with the same combination of values.

    In the example, there are three rows (3,5 and 6) with an Imp value of 4 and a Rat value of 3. I would like the display to show three "x's" (or another character) separated by commas in the cell that corresponds to Imp of 4 and Rat of 3.


    Matrix Capture.JPG

    I'm an experienced Excel user, but not in macros/VBA, so may need some guidance there as well. Thank you.

  2. #2
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi Lis7,

    Welcome to ExcelFox !!

    In F3 and copied down and across,

    =MID(REPT(",x",SUMPRODUCT(--($B$3:$B$9=$E3),--($A$3:$A$9=F$2))),2,255)
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

Similar Threads

  1. Delete Rows Based on Conditions
    By AbiG2009 in forum Excel Help
    Replies: 6
    Last Post: 12-26-2018, 01:24 PM
  2. Replies: 4
    Last Post: 03-22-2013, 01:47 PM
  3. Subtraction Of Series Of Cells' / Array Values
    By PcMax in forum Excel Help
    Replies: 6
    Last Post: 10-26-2012, 11:55 PM
  4. Custom Spin Button Based On Values Passed From Array
    By Preeti Verma in forum Excel Help
    Replies: 7
    Last Post: 05-22-2012, 07:23 PM
  5. Format Cells Based on Given Input
    By Rajesh Kr Joshi in forum Excel Help
    Replies: 10
    Last Post: 08-23-2011, 11:19 AM

Posting Permissions

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