# Permutations

1. ## Permutations

Hi,

I have 13 letters, a, b, c, d,.......m.

I need to list all possibilities that use 5 letters any any order.

Please can someone give me the formulas for A1, B1, C1, D1, E1, that I can copy down for 371,293 rows? Thank you.

I have found a similar post- that was for 12 letters in any 3 letter combination. The formulas for A1, B1 and C1 where

in A1 put
=CHAR(65+TRUNC((ROW()-1)/144))

in b1 put
=CHAR(65+MOD(TRUNC((ROW()-1)/12),12))

in C1 put
=CHAR(65+MOD(ROW()-1,12))

then copy these down the 1728 rows

Thank you

Christopher

2. ## Re: Permutations

That number includes repeating letters, right?

3. ## Re: Permutations

Hello,

I think so- I just followed the other post I found- it had 12 letters and was three letter combinations, 12*12*12. Mine is for 13 letters and I want 5 letter combinations, 13*13*13*13*13

Christopher

4. ## Re: Permutations

Right.

Is "aaaaa" valid?

5. ## Re: Permutations

Assuming it is, see the attachment to http://www.excelforum.com/2334408-post6.html

6. ## Re: Permutations

Hello, a,a,a,a,a is valid.

I have opened up the spreadsheet- unfortunately I can't make sense of it

Christopher

7. ## Re: Permutations

See attached. Convert to an Excel 2007 workbook and copy the formulas down a long way.

8. ## Re: Permutations

Got to grips with it- thank you very much- excellent tool

Christopher

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

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