Results 1 to 3 of 3

Thread: random subset

  1. #1
    Join Date
    Jun 2005
    Posts
    43

    Unanswered: random subset

    greetings:

    i have an excel spreadsheet that has > 1000 rows (records). i'd like to randomly select 78 of these rows and place them in another worksheet w/in this file.

    any suggestions?
    Mos

  2. #2
    Join Date
    Jun 2005
    Posts
    43
    ok, i've gotten a little further, but...

    i went to Tools > Data Analysis > Sampling, and i can get 78 random records, selecting the column "id," when is a number field. but the accompanying columns that are text are not coming along with it. any thoughts here?
    Mos

  3. #3
    Join Date
    Jun 2005
    Posts
    43
    got a little further. am able to do it w/the rand() function and an advanced filter. but, can get, say 10% of records. i want a specific number of records. any thoughts?
    Mos

Posting Permissions

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