+ Reply to Thread
Results 1 to 10 of 10

Generate all possible combinations between 3 letters

  1. #1
    Registered User
    Join Date
    02-27-2013
    Location
    Porto
    MS-Off Ver
    Excel 2010
    Posts
    94

    Generate all possible combinations between 3 letters

    Hi guys,

    Could you help me with this?

    Basically what I need is:

    If I have the letters "abc": It would give me: "abc", "acb", "cab", "cba", "bac", "bca".

    The programme I have is only giving me "abc".

    Can you please help me?

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Generate all possible combinations between 3 letters

    Hi rcprito,

    Try the following code:
    Please Login or Register  to view this content.
    Lewis
    Last edited by LJMetzger; 09-17-2015 at 07:51 PM. Reason: Added items in red to code which were omitted in error.

  3. #3
    Registered User
    Join Date
    02-27-2013
    Location
    Porto
    MS-Off Ver
    Excel 2010
    Posts
    94

    Re: Generate all possible combinations between 3 letters

    Hello. Thank you for your answer.

    It doesn't work. What do I have to change? I can't understand.

    Thank you

  4. #4
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,516

    Re: Generate all possible combinations between 3 letters

    This file was hanging around on my machine.
    See attached
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    02-27-2013
    Location
    Porto
    MS-Off Ver
    Excel 2010
    Posts
    94

    Re: Generate all possible combinations between 3 letters

    It's working. Thanks a lot!

    Is there any other way to introduce more than 12 letters?

    Thank you!

  6. #6
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Generate all possible combinations between 3 letters

    The file would be over 5000 MB. What would you do with it if you had it?
    Entia non sunt multiplicanda sine necessitate

  7. #7
    Registered User
    Join Date
    02-27-2013
    Location
    Porto
    MS-Off Ver
    Excel 2010
    Posts
    94

    Re: Generate all possible combinations between 3 letters

    Nothing really. Curiosity!

    I have another doubt, could you please help me?

    From the programme above, how from 10 letters can we write all the possible words with 3 of these letters?

    Thank you

    Please Login or Register  to view this content.

  8. #8
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Generate all possible combinations between 3 letters

    Items in red in post #2 were omitted in error. I apologize for the inconvenience.

    Lewis

  9. #9
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Generate all possible combinations between 3 letters

    From the programme above, how from 10 letters can we write all the possible words with 3 of these letters?
    See the following code, which outputs the results in Column 'A' and Column 'B' of the Active Sheet:
    Please Login or Register  to view this content.
    Lewis
    Last edited by LJMetzger; 09-18-2015 at 12:16 PM. Reason: Line in red corrects error that erased entire sheet

  10. #10
    Registered User
    Join Date
    02-27-2013
    Location
    Porto
    MS-Off Ver
    Excel 2010
    Posts
    94

    Re: Generate all possible combinations between 3 letters

    Thanks a lot. It's perfect!

+ 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. [SOLVED] Generate Combinations Using VBA
    By NeedForExcel in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 06-06-2021, 01:10 AM
  2. Finding combinations of 8 letters
    By macaonghus in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-19-2015, 02:20 AM
  3. Generate all possible combinations
    By muttleychess in forum Excel General
    Replies: 7
    Last Post: 09-22-2014, 02:39 PM
  4. How to generate all possible combinations of nine cities
    By Nikolas1988 in forum Excel General
    Replies: 2
    Last Post: 06-09-2014, 09:21 AM
  5. [SOLVED] how to generate combinations in excel
    By sgrondines in forum Excel General
    Replies: 5
    Last Post: 08-13-2012, 07:24 AM
  6. Generate combinations
    By cjt_choccy in forum Excel General
    Replies: 6
    Last Post: 11-20-2011, 02:51 PM
  7. Find all possible combinations of letters
    By Double-R in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-26-2010, 09:09 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