+ Reply to Thread
Results 1 to 6 of 6

Need Help for a Formula or Script on outputting Permutations List

  1. #1
    Registered User
    Join Date
    12-06-2021
    Location
    Boston
    MS-Off Ver
    Latest
    Posts
    18

    Question Need Help for a Formula or Script on outputting Permutations List

    Hi -

    First time poster here, just joined.

    I need to create an excel sheet that allows me to take 6 names and see all the permutations for 2 available slots.

    ex)

    list 1 (names)

    Mary
    Jon
    Jim
    Bob
    Bruce
    Carolyn

    list 2 (seats)

    1st Seat
    2nd Seat

    the key is I need all permutation, not combinations. So Mary and Jon could be 1st and 2nd seat, but another permutation is Jon and Mary in 1st and 2nd seat.

    I am hoping whoever helps - it can be something I can use and change the variables in the two lists as needed over time.

    hoping for a solution!!

    Billy

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,005

    Re: Need Help for a Formula or Script on outputting Permutations List

    See attached
    Attached Files Attached Files
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  3. #3
    Registered User
    Join Date
    12-06-2021
    Location
    Boston
    MS-Off Ver
    Latest
    Posts
    18

    Re: Need Help for a Formula or Script on outputting Permutations List

    I appreciate the work on this. Hoping you can help me get a step further.

    I want to be able to change the names (and be able to change the amount of names) and the same for the seats (right now there is 2 seats, but maybe it's 3 or 4 at some point).

    would you be able to adjust this that way?

    fair warning - I am not a heavy excel user, this is above my pay grade, and just trying to get this setup for work.

    thank you in advance!

    Billy

  4. #4
    Registered User
    Join Date
    12-06-2021
    Location
    Boston
    MS-Off Ver
    Latest
    Posts
    18

    Re: Need Help for a Formula or Script on outputting Permutations List

    apologies - just saw the 2nd tab. so I can just change to my own inputs and this works as well. I did not realize that. thank you this is solved!

  5. #5
    Forum Expert
    Join Date
    01-25-2011
    Location
    Belgium, Alveringem
    MS-Off Ver
    Excel 2003, 2007, 365
    Posts
    1,418

    Re: Need Help for a Formula or Script on outputting Permutations List

    See J19:K19
    there you have 3 Janus, 3 Deerfield and 2 Adage which are almost the same in that cell.
    So the answer isn't that simple.
    See K22:L39
    Attached Files Attached Files
    Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

  6. #6
    Registered User
    Join Date
    12-06-2021
    Location
    Boston
    MS-Off Ver
    Latest
    Posts
    18

    Re: Need Help for a Formula or Script on outputting Permutations List

    I very much appreciate this work but I'm having trouble understanding it.

    is there a way to show the highest amount of pairing occurrences from names that appear together from my list of 10 names? a simple output to look at without having to look at the raw data here?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. List permutations of sets?
    By BigShep in forum Excel General
    Replies: 19
    Last Post: 06-05-2019, 10:43 AM
  2. Way to list out all permutations of a set of numbers
    By Namejs in forum Excel General
    Replies: 6
    Last Post: 05-22-2015, 05:21 AM
  3. [SOLVED] Finding a value in a list, then outputting the cell to the right
    By Yoshi64 in forum Excel General
    Replies: 6
    Last Post: 01-07-2014, 05:46 AM
  4. List combinations/permutations + SUM
    By pella88 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-23-2013, 01:18 PM
  5. [SOLVED] List all Permutations of two lists
    By Anthonyinnz in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-27-2013, 07:55 PM
  6. Outputting data from list in one worksheet to another
    By banessa in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-11-2012, 04:09 AM
  7. how to list all permutations?
    By foxxkat in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-10-2005, 02:58 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1