10+ variables with 15 options - how to auto fill out an overview

Dear all,

I have a list of more than 10 variables (panels) which each have 15 different (colors) they can have. I need to make a complete overview of all the possible combinations. Each line must be unique.
Is there a clever and easy way to do so in Excel?

Thank you so much in advance.

/morten

Your file just seems to be populated with the number 2001, so it hardly seems representative of what you are trying to achieve.

You could list your ten panels down a column and have the 15 colours going across at the top of the table, then fill in the cells of the table as appropriate.

Hope this helps.

Pete

Hi Pete,
Tanks. The file should include all possible combinations. All panels can be any of the 15 colors (2001 is just one of them). Any idea to how to fill out each row? Thank you.

Hi Mike,
Tanks. it is a lot of combinations. The file should include all possible combinations. All panels can be any of the 15 colors (2001 is just one of them). Any idea to how to fill out each row?

/ thank you