# Thread: 12 unique combinations in Excel with random-ness

1. ## 12 unique combinations in Excel with random-ness

Hello - I need a way to take numbers 1 through 12 and make 12 different "sets" where each number is in a different position of the "set".

That probably doesn't make sense so i've attached a spreadsheet.

COL A has 1 through 12. Row 1 has 1 through 12.

Row 2 needs to start with 2 (A2=2) but B2:L2 needs to randomize 1-12 (not including 2, since it's already in A2)

Row 3 needs to start with 3 and B3:L3 needs to randomize 1-12 (not incl 3)

So the yellow highlighted numbers in the attached file need to be randomized not including the number in COL A.

Are there formulas I can use to do this? Thanks for the help.

2. someone told me you need too use Latin Square formulas. Don't know what those are

3. Do you want a random latin square, random columns or random rows? A latin square would not have all the columns randomized, all the columns and all the rows would have the 12 unique numbers so it can not be completely random...

Steve