Excel Formula Help (Excel 2003)

Hello,

I am using MS Excel 2003.


For a project, i have to generate 1000+ (and continue) random names in 'First name - Last name' format. Its almost impossible to write all those names.

This is what that can be useful: i write 50 first names at a column (column A), and 100 last names in another (say .. column B) column, then set a formula to another sheet which can take a first name, then a last name (randomly) and make a full name (where, there cannot be any repeats).

what would be the formula ... or any workarounds that can do the similar job ? please ....

Originally Posted by boka

Hello,

I am using MS Excel 2003.


For a project, i have to generate 1000+ (and continue) random names in 'First name - Last name' format. Its almost impossible to write all those names.

This is what that can be useful: i write 50 first names at a column (column A), and 100 last names in another (say .. column B) column, then set a formula to another sheet which can take a first name, then a last name (randomly) and make a full name (where, there cannot be any repeats).

what would be the formula ... or any workarounds that can do the similar job ? please ....

=INDIRECT("A"&INT(RAND()*100+1))&" "&INDIRECT("B"&INT(RAND()*100+1))

should suffice
---