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
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