Variations in Excel

[raze93]

I need help creating variations in excel sheet, Basically I have certain values in a cell and want to create the possible outcomes of that particular cell

How to make that happen? If you want I can attach an image as well

Thanks

[raze93]

Capture.PNG

File attached

Basically a formula to create those variations them selves and I don't have to type every single one

Thanks

[Tony Valko]

Many members are unable to see images in the *.png format due to forum compatibility issues with some browsers.

If you need to post an image post it in the *.jpg format.

Even better than posting images... post a SMALL sample file. That way we can test solutions directly in the file with the relevant data.

[raze93]

Capture.JPG

Attached a .jpg format

trial.csv

Attached a excel file

Thanks

[newdoverman]

Can you mock-up what you expect to see as a result? I looked at your workbook but I really don't understand what the result should be.

[raze93]

Well basically,

I will explain a bit as well

What i require is, that I have got a relationship between size and main colour

I want excel to generate all the possibilities which are the variations itself rather that me typing in

So if the given sizes are

S
M
L

and the main colour is

Black
White

The possibilities are

Size S; Colour Black
Size S; Colour White

Size M; Colour Black
Size M; Colour White

Size L; Colour Black
Size L; Colour White

Instead for me to type all these, a formula for excel to create the variations/possibilities itself

I am attaching what it starts from and what it will look like

Thankstrial.JPG
Result.JPG