Name Generator

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Excellent, thank yo ujust what I needed.

Mark

T. Valko said:
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.
Click to expand...
 
Back
Top