word quiz question

M

Mark Scott

I have been given 15 groups of 3 letters each. I have been asked to make a
15 letter word out of each.

How can I get Excel to give me every permutation of each group IE

aaa bbb ccc
aaa ccc bbb
bbb aaa ccc
bbb ccc aaa
.....

Cheers

Mark
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

reverse lookup function, index/match usage? 3
multiple dependent drop down lists 6
Report Question 3
Extract data in rows (with line breaks) to form a table 0
insertm line and subtotal on separate worksheet 1
Adding data in columns based on criteria in more than one column.. 6
Formula require for complex lookup 4
INDEX MATCH formula 8

Top