Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    Apr 2011
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Importing (truly) random integers

    I need to import a column of 100 truly random numbers into Excel, to appear in a column starting at cell D7 on Sheet 1. In my browser, the address:

    http://www.random.org/integers/?num=...t=html&rnd=new

    produces exactly what I want, but in my browser, not in XL. Putting the address in a cell in XL seems to have no effect. What I would really like is to be able to press F9 in XL and get a new set of random numbers, just like that. Is it possible? What am I missing?

    I would appreciate any help.

    Brian

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Brian,

    Ok, here are the steps:

    1. Select the Data Tab
    2. Click From Web
    3. Enter the entire contents of the Browser Address Bar when displaying a set of random numbers.
      Ex: http://www.random.org/integers/?num=...t=html&rnd=new
    4. Click the Go button at the right of the Address bar
    5. Click the Yellow & Black Arrow just above the first random number
      Random1.JPG
      Note: It will highlight the number table and turn the arrow into a green & black check mark
    6. Click the Import button
    7. Tell it where you want to import it to
      Random2.JPG
    8. Click OK
    9. Done


    To update the list use the Refresh All icon on the Data Tab.

    HTH

    Update: Here's a printable version of this post. Thought some might find it useful to keep.
    Excel 2010 - Importing Web Data that is Refreshable.pdf
    Last edited by RetiredGeek; 2013-09-14 at 11:27.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    New Lounger
    Join Date
    Apr 2011
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Many thanks for your help. The only glitch is that I found that the column of figures is imported by inserting a new column to the left of D7, where I want the column of numbers to start. Maybe that was because the column from D7 downwards was already occupied..?

  4. #4
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    bxcfilm,

    I haven't tested that but once you correct the problem and get the 1st set imported hitting the Refresh All will just replace the existing set. HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  5. #5
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,822
    Thanks
    134
    Thanked 481 Times in 458 Posts
    Hi RG

    I went to that site and imported 100 'truly random' integer numbers between 0 and 100.
    Of the 100 integer numbers I imported, their values were all below 37!!!!!
    I was less than impressed.

    I would be interested to know why the Excel RANDBETWEEN() function would not be sufficient?????
    It is easily adapted to also ensure, if required, that there are non-repeating values.
    And don't get me started on the concept of 'truly random'.
    How can you prove that!
    You can of course use statistical methods to 'suggest' a certain quality of 'randomness'.
    But there you go..

    zeddy

  6. #6
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Zeddy,

    I was just answering the OP's question as posed you'll have to ask him why the Excel function isn't sufficient.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  7. #7
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,822
    Thanks
    134
    Thanked 481 Times in 458 Posts
    Hi RG

    You answered the OP's question brilliantly!
    I was impressed with your solution.
    ..It was just the numbers on the site I didn't like!

    zeddy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •