+ Reply to Thread
Results 1 to 7 of 7

List all unique 5 character combinations from a single column list of 28 characters

  1. #1
    Registered User
    Join Date
    12-03-2012
    Location
    Nebraska, USA
    MS-Off Ver
    Excel 2013
    Posts
    9

    List all unique 5 character combinations from a single column list of 28 characters

    I have a list (single column) of 28 unique numbers. I need to generate a listing of all unique 5-number combinations of those 28 numbers. Excel "COMBIN" function tells me that will be 98,280 combinations so an Excel worksheet should be able to handle the load (my Excel can go to over a million rows) . I am using Office 365, Windows 10. I have spent several hours searching for solutions, both here and on other pertinent forums, but to no avail. I have found several quasi-solutions involving combining data from multiple columns, but my data is 1 column. Any help/direction/advice will be appreciated.

    Thanks in advance.

  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,366

    Re: List all unique 5 character combinations from a single column list of 28 characters

    Please see yellow banner at top of page on how to post a sample workbook.
    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-03-2012
    Location
    Nebraska, USA
    MS-Off Ver
    Excel 2013
    Posts
    9

    Re: List all unique 5 character combinations from a single column list of 28 characters

    As requested.
    Attached Files Attached Files

  4. #4
    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,366

    Re: List all unique 5 character combinations from a single column list of 28 characters

    See attached
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    12-03-2012
    Location
    Nebraska, USA
    MS-Off Ver
    Excel 2013
    Posts
    9

    Re: List all unique 5 character combinations from a single column list of 28 characters

    Pure gold ... exacly what I needed. Thank you very much!

  6. #6
    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,366

    Re: List all unique 5 character combinations from a single column list of 28 characters

    Can you please marked as Solved: see "Thread Tools" at top of page.

    Thank you

  7. #7
    Registered User
    Join Date
    12-03-2012
    Location
    Nebraska, USA
    MS-Off Ver
    Excel 2013
    Posts
    9

    Re: List all unique 5 character combinations from a single column list of 28 characters

    Marked "Solved", as requested. Thanks again.

+ 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. Extracting Unique List From Multiple Columns Based on Single-Column Criteria
    By Hellogiraffe in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-29-2019, 04:55 PM
  2. Replies: 2
    Last Post: 06-16-2016, 08:09 PM
  3. Replies: 9
    Last Post: 10-14-2013, 07:55 PM
  4. List all Possible Character Combinations
    By LKASPER66 in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 03-11-2013, 09:23 AM
  5. Unique Combinations List
    By tonynap in forum Excel General
    Replies: 1
    Last Post: 10-17-2012, 04:00 AM
  6. List all combinations of 6/36 with unique 4 numbers
    By Martin888 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-13-2012, 10:48 AM
  7. Replies: 7
    Last Post: 02-11-2011, 06:58 AM

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