Results 1 to 3 of 3

Thread: changing alternatives in different sets

  1. #1

    changing alternatives in different sets



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have a sheet (attached here)

    Where i want to give alternatives in a new set like set 1, 2, 3 and so on

    i. e. question and answer will be the same but location of each option should be changed everytime

    can i do that automatically using excel formual that i give command and all alternatives appear in a new way every time

    plz help
    Attached Files Attached Files

  2. #2
    Hi Anmol786, will this help?
    It chooses a random number from 1 to 24 then looks up that combination of 4 answers from the list of all 24 combinations I put in column A.
    Attached Files Attached Files

  3. #3

    change the options automatically

    Quote Originally Posted by Beamer View Post
    Hi Anmol786, will this help?
    It chooses a random number from 1 to 24 then looks up that combination of 4 answers from the list of all 24 combinations I put in column A.

    Wii sure help this one
    think u have a game won
    by just aiming an excel gun
    like our suresh raina and dhawan

    thanks a lot

Posting Permissions

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