Hi all,

I am looking to find a formula or macro that will generate all possible outcomes I need. Let me explain the excel file I have attached. In the file, there are a set of 6 customers. Each customer has a set of outcomes. For example, Customers 1 -4 have 3 possible outcomes, and Customers 5-6 have 1 possible outcomes. If we were to numerate all the possible scenarios, we would have 3^4 or 81 potential scenariosGenerating Outcomes.xlsx. Possible scenarios are:

1) 1, 1, 1, 1, 1, 1 (for this scenario, every customer's outcome is expected to be the first outcome)
2) 1, 2, 1, 1, 1, 1
3) 1, 1, 2, 1, 1, 1

...and so on.

I am looking for a way to generate all these possible scenarios quickly in excel without actually manually writing them out. Like I said, there are 81 of them, and I don't want to go through the trouble of doing that. Does anyone know of anything that will help?

Thank you!