list possible combinations

0

i want to list all possible combinations from each of the items from the colomns that contain the data, taking all the colomns at a time.

the data in colomns are variable and may be increased.

eg. few combinations are:

1,10,2,50,1

1,-20,2,50,1

2,-30,5,100,1.5

each combinations will take all the five items and comma as separator. each combination to be listed in a cell. sample file attached.

Answer
Discuss

Discussion

Your definition of "combination" isn't clear. Why don't you add the desired result for the examples in your worksheet?
Variatus (rep: 1755) Oct 19, '17 at 4:42 am
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login