+ Reply to Thread
Results 1 to 13 of 13

Generating Random Numbers with comparing/aligning

Hybrid View

  1. 07-25-2016, 07:05 PM #1
    JeteMc
    JeteMc is offline
    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

    If I understand the query correctly the following formula will provide random numbers for column A:
    Formula: copy to clipboard 
    =RANDBETWEEN(INDEX(D$3:D$8,MOD(ROW(A6),6)+1),INDEX(E$3:E$8,MOD(ROW(A6),6)+1))
    Attached is a file that demonstrates how the formula is applied.
    Let me know if you have any questions.
    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 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. 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1