agillespie
New Member
- Joined
- Sep 21, 2005
- Messages
- 1
Good morning. Got kind of a tricky issue here that I am trying to resolve without getting into a nasty multiple OFFSET nested in VLOOKUP nested in CONCAT statement. I have a sheet which lists out combinations of individuals associated with a specific piece of information, with each row being unique to that piece of information (ex. Row 1: Person A and B are associated with item 1, Row 2: Person C is associated with item 2, Row 3: Person D is associated with item 3, Row 4: Person A and B are associated with item 4). I am trying to figure out a way to concatenate items associated with each unique combination of individuals in another worksheet. Using the example, the output would be:
Combination Result (including a "," in the CONCAT)
Person A and B 1, 4
Person C 2
Person D 3
Is there any easy way to do this? Many thanks.
Combination Result (including a "," in the CONCAT)
Person A and B 1, 4
Person C 2
Person D 3
Is there any easy way to do this? Many thanks.
