Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Illinois
    Posts
    552
    Thanks
    0
    Thanked 1 Time in 1 Post

    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.
    Attached Files Attached Files

  2. #2
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Illinois
    Posts
    552
    Thanks
    0
    Thanked 1 Time in 1 Post
    someone told me you need too use Latin Square formulas. Don't know what those are

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    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

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •