random number generator

  1. T

    Random number generator between values

    Hey guys, I need a formula to generate random numbers, based off a existing figure and in between values. For example, I have 10456.876, 10654.676… etc in column A. I need it to generate numbers +/- 0.020 based of the values in column A.
  2. R

    Advanced RNG and cell pointing

    Hello everybody and thanks in advance for reading this, I've been toying with an idea for a menu selector. My partner and I usually squabble about what to eat and we've decided to outsource it to a neutral party. We want to load up some excel sheets with dishes we both like, with the required...
  3. S

    Need Help on a Homework Assignment

    Working on something for class. Instructions are as follows: Ask the user for a positive integer (num), below 100. If the user enters a negative number or greater than 100, give a warning and ask to re-enter. Generate 20 positive random numbers between (1- num). Display the generated random...
  4. B

    Generate Random numbers with out using predefined functions

    Ask the user for a positive integer (num), below 100. If the user enters a negative number or greater than 100, give a warning and ask to re-enter. Generate 20 positive random numbers between (1- num). Display the generated random numbers in the range (A1, A20). I know there are random number...
    • bglanton
    • Thread
    • if loop no predefined functions random number generator vba - help
    • Replies: 4
    • Forum: Excel Questions
  5. J

    Random Number Generator with flexible probability

    Hello, I am not sure of the proper terminology of what I am looking for but here is a description... I am looking to create a column of 1,000 results with each cell showing one of two numbers (ideally for me would be a "1" and a "-1"). I would like to be able to change what percentage of the...
  6. F

    Random number from Selection

    Hi, I want to select random value from selection. I have just: Dim my_range() Range("A2").CurrentRegion.Select my_range = Selection How to use Random function to select random value from my selection?
    • Forestq
    • Thread
    • random random data random generated random number random number generator
    • Replies: 4
    • Forum: Excel Questions
  7. M

    Random number generator for a given length

    I need to generate random numbers on certain length that is input by the user. For eg. If the user inputs the value 5, a random number of 5 digits should be generated and user can input any value between 1 and 30 and a number with that many digits should be generated. I searched quite a bit...
  8. B

    Random number generator

    Hi Im looking for simple bit of VBA that if I click will create a random number between 1 and 100. Any help would be appreciated. Cheers

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top