+ Reply to Thread
Results 1 to 6 of 6

Find all possible combinations of letters

  1. #1
    Registered User
    Join Date
    09-25-2008
    Location
    Norway
    Posts
    2

    Find all possible combinations of letters

    I have 8 letters in A1:A8
    a,b,c,d,e,f,g,h

    I want to make a macro to find all possible series of 8
    letters, in which all the letters are used.

    Also the series should not have more than two
    alphabetically consecutive letter following eachother.

    E.g a,b,c, or c,b,a is not allowed, but a,b,d and a,c,b is allowed.

  2. #2
    Valued Forum Contributor rwgrietveld's Avatar
    Join Date
    09-02-2008
    Location
    Netherlands
    MS-Off Ver
    XL 2007 / XL 2010
    Posts
    1,671

    re: Find all possible combinations of letters

    Where do you want the output? I now used range A1:A
    Please Login or Register  to view this content.
    Last edited by rwgrietveld; 09-25-2008 at 03:59 AM.
    Looking for great solutions but hate waiting?
    Seach this Forum through Google

    www.Google.com
    (e.g. +multiple +IF site:excelforum.com/excel-general/ )

    www.Google.com
    (e.g. +fill +combobox site:excelforum.com/excel-programming/ )

    Ave,
    Ricardo

  3. #3
    Registered User
    Join Date
    09-25-2008
    Location
    Norway
    Posts
    2
    Thanks for pointing me in the right direction, however i probably
    didn't make it very clear what i wanted to achieve in the first post.

    I want to generate the whole series of 8 characters, not just the first 3,
    and nowhere in the series should there be more than 2 alphabetically consecutive characters following eachother.

    I.e: a-b-d-e-g-h-c-f

  4. #4
    Valued Forum Contributor rwgrietveld's Avatar
    Join Date
    09-02-2008
    Location
    Netherlands
    MS-Off Ver
    XL 2007 / XL 2010
    Posts
    1,671

    re: Find all possible combinations of letters

    here some code that will make you patient
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    08-26-2010
    Location
    manila, philippines
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: Find all possible combinations of letters

    hi.. i want to find all the possible combinations of 8 characters including letters and numbers.
    The letters should be all capitalized and the combination should be letters and numbers alternately.
    This are the examples:
    C8L8J1A4
    A7C8H2I4
    Q8F9H6D9
    Q1A9C8J9

    Please help me because I really need it. Thank you.

  6. #6
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,982

    Re: Find all possible combinations of letters

    Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.
    Everyone who confuses correlation and causation ends up dead.

+ 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. find a fixed total using combinations of smaller figures?
    By kev.b.123 in forum Excel General
    Replies: 8
    Last Post: 12-29-2009, 01:05 AM
  2. [SOLVED] match 3 hold digits
    By stewart08 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 04-13-2008, 03:30 PM
  3. Find all possible numerical combinations
    By amy22x3 in forum Excel General
    Replies: 4
    Last Post: 03-26-2008, 11:23 PM
  4. Programming a Find Loop?
    By mcbain in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-21-2008, 04:44 AM
  5. Extracting combinations of letters from within a word
    By vicmtl in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-27-2007, 11:25 PM

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