Results 1 to 4 of 4

Combinations on ABCDE

This is a discussion on Combinations on ABCDE within the Excel Questions forums, part of the Question Forums category; Dear All, I need a help in excel where in i am making a number range which is 100ABCDE. I ...

  1. #1
    New Member
    Join Date
    May 2013
    Posts
    1

    Default Combinations on ABCDE

    Dear All,

    I need a help in excel where in i am making a number range which is 100ABCDE. I have around 5 permutations i can add at the end.

    Is there a way to make in excel the below format:

    100AAAAA
    100AAAAB
    100AAABC etc.

    PLEASE HELP!!!!!!!

  2. #2
    Board Regular
    Join Date
    Jan 2009
    Location
    uk bexhill sussex
    Posts
    629

    Default Re: Combinations on ABCDE

    hn2904

    although excel could probably do this

    this website allows you to do just what you require and export the results to excel if you want.

    Combinations and Permutations Calculator

    hope this helps

    dave
    Some one always knows more than me,thats why I am here.

  3. #3
    Board Regular
    Join Date
    Jan 2009
    Location
    uk bexhill sussex
    Posts
    629

    Default Re: Combinations on ABCDE

    LIKE THIS?

    100AAAAA
    100AAAAB
    100AAAAC
    100AAAAD
    100AAAAE
    100AAABB
    100AAABC
    100AAABD
    100AAABE
    100AAACC
    100AAACD
    100AAACE
    100AAADD
    100AAADE
    100AAAEE
    100AABBB
    100AABBC
    100AABBD
    100AABBE
    100AABCC
    100AABCD
    100AABCE
    100AABDD
    100AABDE
    100AABEE
    100AACCC
    100AACCD
    100AACCE
    100AACDD
    100AACDE
    100AACEE
    100AADDD
    100AADDE
    100AADEE
    100AAEEE
    100ABBBB
    100ABBBC
    100ABBBD
    100ABBBE
    100ABBCC
    100ABBCD
    100ABBCE
    100ABBDD
    100ABBDE
    100ABBEE
    100ABCCC
    100ABCCD
    100ABCCE
    100ABCDD
    100ABCDE
    100ABCEE
    100ABDDD
    100ABDDE
    100ABDEE
    100ABEEE
    100ACCCC
    100ACCCD
    100ACCCE
    100ACCDD
    100ACCDE
    100ACCEE
    100ACDDD
    100ACDDE
    100ACDEE
    100ACEEE
    100ADDDD
    100ADDDE
    100ADDEE
    100ADEEE
    100AEEEE
    100BBBBB
    100BBBBC
    100BBBBD
    100BBBBE
    100BBBCC
    100BBBCD
    100BBBCE
    100BBBDD
    100BBBDE
    100BBBEE
    100BBCCC
    100BBCCD
    100BBCCE
    100BBCDD
    100BBCDE
    100BBCEE
    100BBDDD
    100BBDDE
    100BBDEE
    100BBEEE
    100BCCCC
    100BCCCD
    100BCCCE
    100BCCDD
    100BCCDE
    100BCCEE
    100BCDDD
    100BCDDE
    100BCDEE
    100BCEEE
    100BDDDD
    100BDDDE
    100BDDEE
    100BDEEE
    100BEEEE
    100CCCCC
    100CCCCD
    100CCCCE
    100CCCDD
    100CCCDE
    100CCCEE
    100CCDDD
    100CCDDE
    100CCDEE
    100CCEEE
    100CDDDD
    100CDDDE
    100CDDEE
    100CDEEE
    100CEEEE
    100DDDDD
    100DDDDE
    100DDDEE
    100DDEEE
    100DEEEE
    100EEEEE
    Some one always knows more than me,thats why I am here.

  4. #4
    New Member
    Join Date
    May 2013
    Posts
    3

    Default help noobie re: permutations

    how can the permutations of 40 objects, 2 at a time, be viewed and copied in excel 2003

    [ or in any permutation generator program ]?


    the 40 objects are: the 26 alphabet letters, plus ?, @, #, $, 0, 1, 2, 3, 4, 5, 6, 7, 8, and 9.

    on the monitor screen i want to view and copy the 1600 permutations of 2 objects each [ including, if possible, the "doubles?" like 'aa', 'bb'...'99' ]

    [ as if i were to do a matrix by hand, on paper, with the 40 objects across the top and also down the right side. the 1st few matrix cells would contain 'aa', 'ab', 'ac'... and so on thru to
    ... '97', '98' and '99' in the last few cells. ]

    i have moderate pre-calculus math skills. as a permutation noobie i've been seeking this unsuccessfully for several hours.
    [ your reply at my beginner level shall be appreciated in the extreme. ]

    kind regards n tyvm,



    yeehaw
    Last edited by yeehaw; May 15th, 2013 at 03:20 PM.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com