+ Reply to Thread
Results 1 to 2 of 2

Excel Formula Help (Excel 2003)

  1. #1
    Registered User
    Join Date
    10-12-2006
    Location
    USA
    MS-Off Ver
    2007
    Posts
    10

    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 ....

  2. #2
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,196
    Quote 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
    ---

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1