Creating combinations of strings from lists
Creating combinations of strings from lists
(OP)
I have a bunch of lists: lista, listb, listc, listd
I would like to generate a string which is a concatenation of all combinations of these lists, for example:
lista(item1)_listb(item1)_listc(item1)_listd(item1)
...
...
...
lista(itemn)_listb(item1)_listc(item1)_listd(item1)
...
...
...
lista(itemn)_listb(itemn)_listc(itemn)_listd(itemn)
How can I get Excel to help me do this?
Thanks,
Jeff
I would like to generate a string which is a concatenation of all combinations of these lists, for example:
lista(item1)_listb(item1)_listc(item1)_listd(item1)
...
...
...
lista(itemn)_listb(item1)_listc(item1)_listd(item1)
...
...
...
lista(itemn)_listb(itemn)_listc(itemn)_listd(itemn)
How can I get Excel to help me do this?
Thanks,
Jeff





RE: Creating combinations of strings from lists
make a table that contains all of the combinations of list item numbers(in separate columns)
use the index() function to pick strings and & to concatenate
example:
___A__B__C__D__E__F__G__H
1| 1 1 1 1 sd asf ae sdf
2| 2 1 1 1 ert qw pu dut
3| 4 1 1 1 sd aer fd awer
4| 1 1 1 2 we qwe fd asr
=index($E$1:$H$4,A1,1)&"_"&index($E$1:$H$4,B1,2)&"_"&index($E$1:$H$4,C1,3)&"_"&index($E$1:$H$4,D1,4)
the above eqn should give sd_asf_ae_sdf if I typed it all correctly