+ Reply to Thread
Results 1 to 4 of 4

random order in a set of words in 1 column

  1. #1
    Beckbeck
    Guest

    random order in a set of words in 1 column

    I'm formulating a questionnaire with a number of stimulus words to be
    presented. I want to be able to put them in random order for a number of
    different documents

  2. #2
    David McRitchie
    Guest

    Re: random order in a set of words in 1 column

    Hi ...,
    The easiest way would be to create a helper column with the function =RAND()
    and sort on the random number generated then remove the helper column.
    More information on the function in your Excel Help.
    ---
    HTH,
    David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
    My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
    Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

    "Beckbeck" <Beckbeck@discussions.microsoft.com> wrote in message news:0C35B73B-2731-491B-BD11-D4D98026AE97@microsoft.com...
    > I'm formulating a questionnaire with a number of stimulus words to be
    > presented. I want to be able to put them in random order for a number of
    > different documents




  3. #3
    Max
    Guest

    Re: random order in a set of words in 1 column

    One way ..

    Assume the words are in A1:A10

    Put in B1:
    =INDEX(A:A,MATCH(SMALL(C:C,ROWS($A$1:A1)),C:C,0))

    Put in C1: =RAND()

    Select B1:C1, fill down to C10

    Col B will return a random shuffle of the words in A1:A10

    Press F9 key to regenerate a fresh shuffle

    Freeze the results elsewhere with a copy > paste special > values elsewhere
    --
    Rgds
    Max
    xl 97
    ---
    GMT+8, 1 22' N 103 45' E
    xdemechanik <at>yahoo<dot>com
    ----
    "Beckbeck" <Beckbeck@discussions.microsoft.com> wrote in message
    news:0C35B73B-2731-491B-BD11-D4D98026AE97@microsoft.com...
    > I'm formulating a questionnaire with a number of stimulus words to be
    > presented. I want to be able to put them in random order for a number of
    > different documents




  4. #4
    Max
    Guest

    Re: random order in a set of words in 1 column

    Here's an extension to the earlier set-up if we want generate more than 1
    randomized shuffle at one go, using Data > Table ..

    Assuming the earlier set-up is in Sheet1

    In a new Sheet2
    --------------------
    Put in A3: =Sheet1!B1
    Copy down to A12

    Put in B2: =COLUMNS($A$1:A1)
    Copy across to say, K2
    (assume we want to generate 10 sets at one go)

    Select A2:K12
    Click Data > Table
    Enter in box for "Row input cell": A1
    Leave "Column input cell" box empty
    Click OK

    What we'll get in B3:K12 are 10 randomized sets of words, in B3:B12, C3:C12,
    .... K3:K12. (11 sets actually if you include the one in A3:A12)

    Pressing F9 will regenerate another 10/11 randomized sets at one go
    (Freeze results elsewhere as before)

    Extend to suit ..
    --
    Rgds
    Max
    xl 97
    ---
    GMT+8, 1 22' N 103 45' E
    xdemechanik <at>yahoo<dot>com
    ----



+ 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