+ Reply to Thread
Results 1 to 2 of 2

Take a fixed cell's value and place it at random between any one of 4 cells

  1. 03-23-2014, 11:31 AM #1
    tlnllc
    tlnllc is offline
    Registered User
    Join Date
    03-23-2014
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2010 Mac
    Posts
    7

    Take a fixed cell's value and place it at random between any one of 4 cells

    I have a cell set for an answer to a multiple choice questions, i want to take the value of that cell and place it at random in any one of 4 cells next to it, how can i best do this? Thanks!
    Reply With QuoteRegister To Reply
  2. 03-23-2014, 12:08 PM #2
    MarvinP
    MarvinP is offline
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,168

    Re: Take a fixed cell's value and place it at random between any one of 4 cells

    Hi tlnlic and welcome to the forum.

    I can do this problem using a Helper Column where I need a random number. See the attached to see if this is what you want.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Random number generation for a fixed given sum
    By abhi16.2007 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-08-2013, 08:00 AM
  2. Fixed Random Function
    By mycon73 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-04-2011, 03:29 AM
  3. Create a random array contain a fixed number
    By nguyennb in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-13-2009, 05:38 AM
  4. Fixed Random Numbers
    By ameyjohn in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-21-2005, 10:13 AM
  5. [SOLVED] Fixed decimal place
    By Cherid in forum Excel General
    Replies: 1
    Last Post: 05-03-2005, 01:06 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1