+ Reply to Thread
Results 1 to 2 of 2

combination of numbers or letters

Hybrid View

  1. 03-04-2014, 05:52 PM #1
    torjan
    torjan is offline
    Registered User
    Join Date
    03-04-2014
    Location
    tunisia
    MS-Off Ver
    Excel 2010
    Posts
    1

    combination of numbers or letters

    Hi
    I am new to your wonderful forum, I love all your programs and I was moved by your performance.
    I am a student, I have a problem in which I seek a solution lot, I really tried but I could not solve it and I want you to help me to find a solution
    So I want EXCEL program that can do all of the possibilities (combinations) possible with the letters a, b, c in character strings composed by 13 elements (elements are a, b and c, that's all, no more)
    then the result is 2,197 strings of 13 letters written by these three letters only, for example:
    aaaaaaaaaaaaa
    abcabcabcabca
    aaaaabbbbbccc
    aabbccaabbcca
    .
    .
    .
    .
    .
    .
    .
    etx
    and Thank you in advance
    Reply With QuoteRegister To Reply
  2. 03-04-2014, 06:20 PM #2
    Kaper
    Kaper is offline
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,873

    Re: combination of numbers or letters

    Unfortunately, your estimation is wrong, You will get 1 594 323 different strings, so more than excel can fit in one column.

    But you can start and see first few (or more

    write in A1 formula:
    =CHAR(MOD((ROW()-1)/3^(COLUMN()-1),3)+97)
    copy it into next 12 columns and then copy all 13 columns some rows down.

    to have letters in one string use in N1:

    =A1&B1& ... &L1&M1
    (of course write all cells in ...)

    and copy down
    Best Regards,

    Kaper
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Removing letters from text & letters combination
    By benoj2005 in forum Excel General
    Replies: 5
    Last Post: 02-26-2014, 11:20 AM
  2. Sum numbers with certain combination of letters
    By sizcorx in forum Excel General
    Replies: 1
    Last Post: 10-09-2010, 09:10 PM
  3. insert combination of random letters and numbers - an example
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-03-2006, 07:25 PM
  4. finding out the combination of letters!
    By via135 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-13-2006, 01:12 AM
  5. [SOLVED] random combination of letters
    By rp in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-16-2005, 10:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1