I'm looking to return a single cell of values that show results matched against one column which are then used to collect their own results. Much easier to explain with a display...
<tbody>
</tbody>
I would like to display each variation of colour and place for an item of clothing combined with the following syntax in a single cell
<tbody>
</tbody>
Is this possible without VBA? I thought I might be able to do some sort of nested array formula using TEXTJOIN but I'm completely stuck now?
Any help massively appreciated!
Clothing | Colour | Place |
Hat | Red | Head |
Hat | Yellow | Head |
Glove | Red | Hands |
Scarf | Blue | Head |
Glove | Green | Head |
Hat | Red | Neck |
Glove | Red | Head |
Scarf | Yellow | Hands |
<tbody>
</tbody>
I would like to display each variation of colour and place for an item of clothing combined with the following syntax in a single cell
Clothing | Combined |
Hat | Red[Head,Neck],Yellow[Head] |
Glove | Red[Hands,Head],Green[Head] |
Scarf | Blue[Head],Yellow[Hands] |
<tbody>
</tbody>
Is this possible without VBA? I thought I might be able to do some sort of nested array formula using TEXTJOIN but I'm completely stuck now?
Any help massively appreciated!