+ Reply to Thread
Results 1 to 13 of 13

Generating Random Numbers with comparing/aligning

Hybrid View

  1. #1
    Registered User
    Join Date
    09-07-2013
    Location
    Denmark
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Generating Random Numbers with comparing/aligning

    Hi tim201110 and Phuocam

    Thanks for your inputs. Both solutions where not the answer that I was looking for. As seen in the sheet above I need the columns A and G to be filled with random numbers, but numbers that will stay inside the range defined in row 3-8. In the sheet you can see row 11 where data in column A is 1 and in column G is 85. That should have been column A=1 (a number between 1-5) and column B=a number between 5-12. So forth all the way through 10000 rows - but with random numbers defined from row 3-8. Do I make myself understandable?
    Last edited by FiberFlux; 07-25-2016 at 12:18 PM.

+ 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. Generating Random numbers that will sum to 1 specific value?
    By zr11 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-24-2019, 10:08 AM
  2. Generating Random Numbers
    By darkblueblood in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-17-2014, 03:10 AM
  3. Generating random numbers
    By softik in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-31-2013, 01:52 AM
  4. Generating a list of Random numbers of random length...
    By Growl in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-19-2013, 12:10 PM
  5. Excel 2007 : generating random numbers with exception
    By scbalaji in forum Excel General
    Replies: 2
    Last Post: 05-16-2012, 02:28 PM
  6. Generating a Random Number of Random Numbers
    By Garrus in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-10-2010, 09:39 AM
  7. Generating Random Number from a set of numbers
    By CalsLib in forum Excel General
    Replies: 3
    Last Post: 03-17-2006, 12:27 PM

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