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
Bookmarks