# 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. ## 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.

2. ## 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

3. ## 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

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

#### Posting Permissions

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