E
exceluser
Is there a way to extract multiple values from an INDEX result ?
For example:
Date Fruit Qty. Inventory
1/1/2010 Apples 10 Apples_10
1/2/2010 Apples 0
1/3/2010 Apples 5 Apples_5
1/4/2010 Oranges 3 Oranges_3,Apples_5
On 1/1/2010, the Inventory column should reflect Apples_10.
On 1/2/2010, the Inventory column should reflect nothing.
On 1/3/2010, the Inventory column should reflect Apples_5.
On 1/4/2010, the Inventory column should reflect Oranges_3,Apples_5.
I can create a formula that contains INDEX({"Oranges_3";"Apples_5"}),
but how would you extract the multiple values in the INDEX ?
Or perhaps, another method can be used to result in concatenated
value ?
For example:
Date Fruit Qty. Inventory
1/1/2010 Apples 10 Apples_10
1/2/2010 Apples 0
1/3/2010 Apples 5 Apples_5
1/4/2010 Oranges 3 Oranges_3,Apples_5
On 1/1/2010, the Inventory column should reflect Apples_10.
On 1/2/2010, the Inventory column should reflect nothing.
On 1/3/2010, the Inventory column should reflect Apples_5.
On 1/4/2010, the Inventory column should reflect Oranges_3,Apples_5.
I can create a formula that contains INDEX({"Oranges_3";"Apples_5"}),
but how would you extract the multiple values in the INDEX ?
Or perhaps, another method can be used to result in concatenated
value ?