Results 1 to 5 of 5
  1. #1
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Random row selection (XL97)

    This one is driving me mad!
    I have just been given a excel worksheet with 40000 names on it. The requester has asked for a random sample of 400 names( with corresponding info) from it. Is there a quick and easy way to get this information out.

    Jezza <img src=/S/crossfingers.gif border=0 alt=crossfingers width=17 height=16>
    Jerry

  2. #2
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Random row selection (XL97)

    Assuming that the names are in Column A, rows 1-40,000:
    1) Insert a blank column B.
    2) Enter =rand() in cell B1
    3) Select B1 and double-click on the little square in the lower-right corner. That auto-fills column B with random numbers.
    4) Data | Sort the data on the sheet by Column B
    5) Select the first 400 rows.
    6) File | Print | Selection
    7) Update your resume to include Statistician <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    HTH --Sam
    Note - you can recalculate (F9) which generates a new set of random number, resort, and reprint. Do this until the requestor has the correct <img src=/S/wink.gif border=0 alt=wink width=15 height=15> data.
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Random row selection (XL97)

    See if This Thread might get you close to what you need.
    Legare Coleman

  4. #4
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Random row selection (XL97)

    SammyB
    So simple, thank you

    JEZZA
    Jerry

  5. #5
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Random row selection (XL97)

    Thank you Legare

    Something to look at on this cold wet evening
    Jezza
    Jerry

Posting Permissions

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