Combination or permutation - Product numbers example

[butti87]

Hello to everybody

I am looking whole day for solution for my problem with combination in excel, but i didnt sucess. So i am turning here on professionals
My excel skills are on basic level to compare with yours.

I have prepared example case, let me show you my problem:

I have some products and i need to create product numbers for them.

I need to create all combination of Products, Colors, Size - production number. (i have created table with production numbers manually - but i would get the same result automaticaly, because i have 10 000 items )

Do you know how to do it ? Do i have to use any functions, or macros ?

Please, if you can help

Link to source file: http://www.ibensoft.sk/data/product number example.xlsx

thanks

 

[shg]

There's a workbook with both formula- and VBA-based methods to do this at https://app.box.com/s/47b28f19d794b25511be

 

[butti87]

Thank you very much, after few hours adjusting it, is that what i have looked for. You helped me a lot of. Many thanks

 

[shg]

You're welcome.