+ Reply to Thread
Results 1 to 2 of 2

Need some help on coming up with random number from 2 excel columns.

  1. #1
    Registered User
    Join Date
    09-15-2011
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    27

    Question Need some help on coming up with random number from 2 excel columns.

    Hi, I need some help in coming up with some random numbers from 2 columns in an excel file.
    excel.png
    If you see on the attached file on column F and G there are some numbers. I need to come up with some random numbers and put them in column H. But the number from column F needs to be a few numbers higher (sometimes a number up, or 2 numbers up, up to three numbers up, but they need to be random throughout the whole column, (like I said sometimes 1 or 2 or 3 numbers up). On column G is the same but the numbers need to go down by 1 or 2 or 3 numbers, just random numbers. On the results on the H column the left number needs to be smaller than the right number. If you see on the attached file the first result in column H .428 is lower than .440 (The number on the left needs to smaller. I'm really trying to come out with a formula but I cant figure it out. Its a long list maybe someone can help me on this if is even possible.

    Thanks in advanced

  2. #2
    Forum Expert
    Join Date
    08-02-2013
    Location
    Québec
    MS-Off Ver
    Excel 2003, 2007, 2013
    Posts
    1,412

    Re: Need some help on coming up with random number from 2 excel columns.

    Hello,
    See attached file. Results in E and F.
    Attached Files Attached Files
    GC Excel

    If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.

+ 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. Replies: 5
    Last Post: 06-21-2013, 10:40 AM
  2. [SOLVED] Compare columns, replace matching number with reference number and fill down random amount
    By datadigger in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-04-2012, 10:53 PM
  3. Convert Excel cells stored as text to date and number coming from notepad
    By Fire_d in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-31-2010, 12:34 AM
  4. Values not coming in few cell but coming in rest all cells
    By rashmib in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-02-2009, 11:19 AM
  5. [SOLVED] stop all the columns coming up the same length in a chart
    By prinshin in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-21-2006, 05:45 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1