ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Creating a concatenate text list by referencing an array (https://www.excelbanter.com/excel-discussion-misc-queries/91325-creating-concatenate-text-list-referencing-array.html)

nothingbutjeep

Creating a concatenate text list by referencing an array
 
I need help creating a formula to create a concatenated list from a matrix by
referencing a second array.

Spread sheet layout: Data

Programs (A:5) Line (B:5)
product 1 1
product 2 2
product 3 1
product 4 1 (B:9)

Starting in Cell A:11 would be the concatenate formula for the Programs,
B:11 would be the Line # (array), starting with 1 and going to 6 (B:17). The
formula criteria would be B:11 thru B:17. So for Line #1 (B:11), A:11 should
show "product 1, product 3, product 4". A:12 would be the formula for Line
#2 showing "product 2". Let me know if you need more info.



All times are GMT +1. The time now is 01:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com