Concatenating array into cells based on conditions

[Lis7]

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.

[Admin]

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)