Hello,
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 one by one.
This is what that can be useful: i write 50 first names at a column, and 100 last names in a 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 ?
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 one by one.
This is what that can be useful: i write 50 first names at a column, and 100 last names in a 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 ?