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

Here's a sample file that will do what you want. It uses Myna Larson's
permutation/combination routine.

http://cjoint.com/?ktwTXS83eq

Just enter the names starting in cell A3 (I put a few in there to give you
an idea).

Then run the macro ListPermutations.

The macro will create a new sheet with all the names.


--
Biff
Microsoft Excel MVP


"maths15" wrote in message
...
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

Excellent, thank yo ujust what I needed.

Mark

"T. Valko" wrote:

Here's a sample file that will do what you want. It uses Myna Larson's
permutation/combination routine.

http://cjoint.com/?ktwTXS83eq

Just enter the names starting in cell A3 (I put a few in there to give you
an idea).

Then run the macro ListPermutations.

The macro will create a new sheet with all the names.


--
Biff
Microsoft Excel MVP


"maths15" wrote in message
...
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

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"maths15" wrote in message
...
Excellent, thank yo ujust what I needed.

Mark

"T. Valko" wrote:

Here's a sample file that will do what you want. It uses Myna Larson's
permutation/combination routine.

http://cjoint.com/?ktwTXS83eq

Just enter the names starting in cell A3 (I put a few in there to give
you
an idea).

Then run the macro ListPermutations.

The macro will create a new sheet with all the names.


--
Biff
Microsoft Excel MVP


"maths15" wrote in message
...
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