+ Reply to Thread
Results 1 to 6 of 6

Creating list of random numbers based on values in other cells

  1. #1
    Registered User
    Join Date
    04-01-2015
    Location
    scotland
    MS-Off Ver
    2010
    Posts
    2

    Creating list of random numbers based on values in other cells

    Hi guys,
    I'm wasn't really sure how to describe what it is I'm trying to do in the title but i'll try explain it as best I can.

    I'm basically wanting to create a list of random numbers using the rand() function, but the number of random numbers is dependent on the input value specified in a different cell. I realise theres probably an easy way to do it but I can't think of what to type in to search for it! Any help would be much appreciated!

  2. #2
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Creating list of random numbers based on values in other cells

    Need more detail about this:

    the number of random numbers is dependent on the input value specified in a different cell
    How about posting some examples.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,905

    Re: Creating list of random numbers based on values in other cells

    What does the input value have to do with the number of random values? Also, RAND() and RANDBETWEEN() both change values every time something is calculated on the workbook. If you want randomized numbers that don't change every time a calculation is ran, besides copy/pasting values, you'd probably want to look into VBA.
    Spread the love, add to the Rep

    "None of us are as smart as all of us."

  4. #4
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: Creating list of random numbers based on values in other cells

    try:
    =RAND()*(B1-A1)+A1
    or
    A random number greater than or equal to 0 but less than 100 (varies)
    =RAND()*100
    Last edited by sandy666; 04-01-2015 at 09:24 AM. Reason: B1 to A1
    sandy
    How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    Tips for Excellent Spreadsheets

    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

  5. #5
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,249

    Re: Creating list of random numbers based on values in other cells

    Hi Ross and welcome to the forum,

    See if my answer attached is what you are asking for.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  6. #6
    Registered User
    Join Date
    04-01-2015
    Location
    scotland
    MS-Off Ver
    2010
    Posts
    2

    Re: Creating list of random numbers based on values in other cells

    Hi Marvin,

    That is exactly what I was looking for thanks so much! If you don't mind, could you explain what each step in the 'IF' function is doing?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] creating and re-creating 'random' numbers from a specific seed that can be recreated
    By OberonViking in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-15-2014, 04:13 PM
  2. [SOLVED] Finding Values in one random list, highlighting, and labeling based on a known list
    By mark00thomas in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-14-2013, 07:41 AM
  3. VBA Creating Expandable Random Values Based on Values on a different Sheet
    By richter394 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-02-2013, 03:14 PM
  4. Replies: 1
    Last Post: 03-26-2012, 05:28 PM
  5. Only two values (numbers) for 150 random cells in a column of 300 cells
    By andrugrasu in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-20-2011, 03:17 AM

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