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.
