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

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

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

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

Christopher

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

Christopher