Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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: 4889) 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