Results 1 to 4 of 4

Create lists of all possible pair combinations (excluding repeats) from cells in every row

Threaded View

  1. #1
    Registered User
    Join Date
    08-04-2012
    Location
    London, England
    MS-Off Ver
    Office 365 64 bit
    Posts
    6

    Question Create lists of all possible pair combinations (excluding repeats) from cells in every row

    I have a spreadsheet with around 50,000 rows. Each row contains a list of values across multiple columns that are associated with each other (like attendees at a party).

    I'd like to turn each row into a new list that combines the cells in that row into every possible paired combination, like this:

    combinaitons-example.PNG

    In effect, the result is showing how every cell in each row can be combined in pairs without repeats (i.e. 1,2 can represent 2,1 without needing to actually list 2,1).

    • The number of values in each row differs, ranging from 3 to 10
    • As shown in the screenshot and attached example spreadsheet, I'd like the solution to stack each list, preferably in a new spreadsheet to maximize the number of available rows before hitting memory limits

    Many thanks for any help you can provide!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VB script to create different combinations based on a list - no repeats
    By Tonx in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-15-2020, 11:19 AM
  2. Random Lists with no Repeats
    By cliff2017 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 01-29-2017, 02:03 PM
  3. Replies: 5
    Last Post: 01-23-2017, 12:05 PM
  4. Finding first five items in a pair of lists under specific conditions
    By david.aukerman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-13-2013, 11:27 AM
  5. Replies: 1
    Last Post: 06-14-2013, 04:06 PM
  6. [SOLVED] Create a list excluding cells with a certain value
    By bluehour84 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-04-2012, 02:33 PM
  7. Unigue combinations of a set of numbers w/ no repeats
    By jeremy3721 in forum Excel General
    Replies: 8
    Last Post: 11-02-2007, 10:09 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