Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jun 2005
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have a spreadsheet that consists of several names. I need to randomly select several names from this spreadsheet. What formula do I insert into the spreadsheet for it to randomly select those name for me? Thank you in advance.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    If you want to draw a random sample:

    Let's say your names are in A1:A100.
    In B1, enter the formula =RAND()
    Fill down to B100.
    Click in cell B1.
    Click the Sort Ascending button on the Standard toolbar (or on the Data tab of the ribbon if you're using Excel 2007 or later).
    For a sample of 7 names, take the names in A1:A7; in general, for a sample of n names, take the top n cells in column A.
    Each time you sort on column B, the names in column A will be shuffled.

  3. #3
    3 Star Lounger
    Join Date
    Feb 2003
    Location
    Runcorn, Cheshire, United Kingdom
    Posts
    372
    Thanks
    0
    Thanked 2 Times in 2 Posts
    Quote Originally Posted by NancyO View Post
    I have a spreadsheet that consists of several names. I need to randomly select several names from this spreadsheet. What formula do I insert into the spreadsheet for it to randomly select those name for me? Thank you in advance.
    If your names are in a Named Range in column A, (in this example "NameList"), the following formula will give you a random name in a cell.

    =INDIRECT("A"&INT(RAND()*ROWS(NameList)+1))

    Hitting F9 will re-calculate the random number generator and give you a fresh random name.

Posting Permissions

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