permutation/combination routine

[maths15]

Hi

As a soon to be father we have a list of 1st and 2nd names. I want to
create a spreadsheet where I bang in these two lists and it then shows all
the permutations with the surname.

What formula/s do I need to use for this, or better still can anyone point
me in the direction of a completed spreadsheet with the formulas already
written?

thanks

Mark

 

[L. Howard Kittle]

Hi Mark,

Conrad's on the baby.

I have a workbook that generates Corporate Speak, you know all the new catch
words/phrases and such that CEO's like to banter about. It randomly selects
a verb, an adjective and a noun on the click of a button and lists the
results on the worksheet. It would seem you could replace the verb,
adjective and noun column with your names. Perhaps you need only two
column. It might be prone to duplicates, however.

You are welcome to the workbook.

Regards,
Howard

 

[maths15]

Hi Howard

That's sounds like the ticket, can you email it to me?

Many thanks

Mark

 

[Bernard Liengme]

This topic comes up often. Try a Google (search newsgroups) with "Excel
permutations"
Myrna Larson's XLS file with a demo is available form
http://www.savefile.com/files/518493

best wishes

 

[Dana DeLouis]

Hi. Just 2 cents. :>)
With two vectors, the program is usually called an "Outer Product" vs
Combinations/Permutation.
....Except we don't multiply, but make a list.

http://en.wikipedia.org/wiki/Outer_product

For j= 1 to n
for k = 1 to m
First(j) & Middle(k)
...etc

- - -
Dana DeLouis

 

[maths15]

excellent, thank you very much

mark

This topic comes up often. Try a Google (search newsgroups) with "Excel
permutations"
Myrna Larson's XLS file with a demo is available form
http://www.savefile.com/files/518493

best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

 

[L. Howard Kittle]

Hey Mark,

What name did you come up with????

Regards,
Howard