+ Reply to Thread
Results 1 to 13 of 13

Generating Random Numbers with comparing/aligning

Hybrid View

  1. #1
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    18,847

    Re: Generating Random Numbers with comparing/aligning

    You might add rows and accomplish something close to what you are asking. change row 3 so D3 is 4 and E3 is 5. Insert a new row 4 where D4 is 1 and E4 is 3 (and new row 5 where D5 is 1 and E5 is 3 which will be needed due to separating the 5-12 range on the right side). Add another index number (.048) and value (7) in choose. The 'random busting' part, in my mind, would be on the right side where J3 and K3 would be 10. J4 would be 5 and K4 would be 9, you would then need to insert another row so that J5 could be 11 and K5 could be 12. Reset the Choose again adding index number .064 and value 8. This would mean that 10 would be chosen 60%, 5,6,7,8 or 9 would be chosen 20% and 11 or 12 would be chosen 20% of the original 8% that was designated to be 5-12. (I hope that makes some amount of sense.) I did not tackle any of the other ranges in the attached file as I am not sure that this approach is acceptable.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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