+ Reply to Thread
Results 1 to 3 of 3

Randomly Choose Cells from Colum/Row

  1. #1
    J
    Guest

    Randomly Choose Cells from Colum/Row

    hello. i'm not sure if this is possible, but i'm trying to randomly select
    multiple cells from a colum to be evaluated. for example, say i have a clumn
    of 10 cells. i'd like this function in another cell to select 3 cells from
    the 10 at random. is this possible? thanks

  2. #2
    Gary''s Student
    Guest

    RE: Randomly Choose Cells from Colum/Row

    In a column next to the column containing the ten data items enter:

    =RAND() and copy down. Touch F9 and then sort by the newly entered column.
    This will "randomize" your data. Just take the top three cells.

    Whenever you want a new sample, repeat the process
    --
    Gary''s Student


    "J" wrote:

    > hello. i'm not sure if this is possible, but i'm trying to randomly select
    > multiple cells from a colum to be evaluated. for example, say i have a clumn
    > of 10 cells. i'd like this function in another cell to select 3 cells from
    > the 10 at random. is this possible? thanks


  3. #3
    Max
    Guest

    Re: Randomly Choose Cells from Colum/Row

    Another variation to try ..

    Assume the 10 source items are listed in A1:A10

    Put in B1: =RAND()
    Copy B1 down to B10

    Put in C1: =INDEX(A:A,RANK(B1,$B$1:$B$10))
    Copy C1 down to C3

    C1:C3 will return a random, non-repeating selection
    of 3 items from within A1:A10

    And if you want to random select more than 3 items,
    just copy C1 down further to C4, C5, .. or all the way to C10
    to get the random full scramble of what's in A1:A10

    To regenerate a fresh random selection, just press F9
    --
    Rgds
    Max
    xl 97
    ---
    Singapore, GMT+8
    xdemechanik
    http://savefile.com/projects/236895
    --
    "J" <J@discussions.microsoft.com> wrote in message
    news:C02D96E4-9408-466E-B267-C54316D9FBD7@microsoft.com...
    > hello. i'm not sure if this is possible, but i'm trying to randomly select
    > multiple cells from a colum to be evaluated. for example, say i have a

    clumn
    > of 10 cells. i'd like this function in another cell to select 3 cells from
    > the 10 at random. is this possible? thanks




+ 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