+ Reply to Thread
Results 1 to 5 of 5

creating a test /scambling the words.

  1. #1
    Registered User
    Join Date
    07-10-2007
    Location
    Turkey-Bartın/
    MS-Off Ver
    Ms Office-2007
    Posts
    44

    creating a test /scambling the words.

    Hi,
    I am tring to prepare an English test in which I want to
    Scramble the words in the sentences and ask the students to re-arrange
    /put the words in the correct order again. So I need a program that
    will do the scrambling the words randomly.
    for example: "My sister likes drinking coffe with milk" The scambled form may be " milk-my-likes-coffee-sister-drinking-with"

    In the first row I have my first original sentence and in the second row I want
    my scrambled sentence to be generated.

    But I have 10 sentences which need to be scrabled as in the attached file.

    Thanks a lot.
    Attached Files Attached Files
    Last edited by gencoglu27; 03-24-2012 at 07:23 AM.

  2. #2
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: creating a test /scambling the words.

    Hi, a possible solution (no Vba) is to write in M1:M9 (9 positions)

    Please Login or Register  to view this content.
    in N1 to be copied down in N1:N9:

    Please Login or Register  to view this content.
    in j1

    Please Login or Register  to view this content.
    Press command F9 to scramble.

    Hope it helps.
    Attached Files Attached Files
    -----------------------------------------------------

    At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.

    Please, mark your thread [SOLVED] if you received your answer.

  3. #3
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: creating a test /scambling the words.

    Please see attached file. Sheet Sayfa2 is assigned the random generation of words from the sentences from Sayfa1. Run the ReArrange procedure to clear and generate randomization of your sentences.
    Attached Files Attached Files
    If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.

    ---Keep on Coding in the Free World---

  4. #4
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: creating a test /scambling the words.

    this does it, workbook calculation is set to manual press f9 to randomise
    see sheet 2 random sentence and sheet3 for calculations
    Attached Files Attached Files
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  5. #5
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: creating a test /scambling the words.

    @canapone rand() can produce duplicates unlikely ,but simple ranking in an index doesn't work properly when it does.

+ 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