random numbers

  1. M

    Get 4 random numbers divided to 2 pairs with established max and min values to get given sum

    Hello all, I would like to politely ask you for help to solve my little problem. I have already worked with generating random numbers before and have tried to look up for solution, but this is probably more delicate problem than just generating random numbers. Previously i used just this...
  2. BonScie

    Generate a set of random numbers with the specific AVERAGE

    Hi there, upon searching around the net I came across with Mr.Eric W.'s reply with one of the post here regarding generating random numbers with target overall total. Link: generating a set of random numbers to total a set value I have pretty much same problem but the target is AVERAGE of the...
  3. H

    Draw random numbers from 1 to 20 million and save results from the draw

    Hi everyone! Could anyone tell me how it is possible to sort random numbers (without repetition) between a range of 1 to 20 million? Basically I need to enter the drawn range into two cells (minimum value and maximum value) and display the number generated in another cell. Would there also...
  4. R

    Non-repeating list of random numbers between 0001 and 9999, only need 2051 of the 9999

    Hi, I want to generate a list of non-repeating random numbers between 0001 and 9999, but I only need a total of 2051 of the 9999 I want to have 5 separate / individual columns, each with one set of non-repeating numbers. Any suggestions, comments, ideas welcome. Thanks
  5. V

    VBA Random Samling, No Duplication. Inputs: Population Size, Sample Size

    Hello everyone, I performed a small research but could not identify a code for my need. I want to create a sampling file in excel, that will have the population size in cell b2, and the required sample size in cell b5. (The required sample is to be up to 40.) I want to create a macro that...
  6. W

    How to come out with a random number from a field that have text and numbers.

    Hi I need help on excluding text from a cell and come out with a random number up to 3 numbers. Please see the attached image; If you notice in column D there is text and a number that starts with a decimal, for example on the first row is .437 the next row is .215 next row is .63 etc... Is...
  7. W

    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. 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...
  8. N

    Create random numbers in a column with no repeats

    I attempting to create a formula that will create random numbers in a column without repeats. For example, I have a spreadsheet with two columns. The first column I want to contain the random numbers and the second column will contain names. I just need the formula to create the random numbers...
  9. Z

    Rrandom Numbers with no Duplicate

    Hi, I need 13 random numbers from cell A1 to A13 if i press the button all cells should select random numbers but each cell should not have duplicate number from A1 TO A13. please help. thanks alot. regards
  10. apgmin

    random number formula

    I need a formula to generate random numbers between 0.95 to 1.15 only and only in 2 digits after decimals Please help
  11. P

    VBA Random Sequence Algorithm

    Hi, Suppose you'd like a sequence of length n composed of random integers between 0 and x. Furthermore, the sum of the sequence must be y. Repetition within the sequence is permitted. The output should come out starting at A1 and end at An. Is there an efficient algorithm that can do this in...
  12. Y

    Randomly selecting a certain repeating number in a matrix

    I am trying to randomly select a repeating number in a matrix. I have seen the different random number and random select codes out there, but specifically what I'm asking is how to go about selecting a number that repeats in a matrix multiple times, not numbers between a certain range or a...
  13. J

    Array of Random & Non-Duplicated Values Which Meet a Sub-Criteria

    Hi All, Bit of a tough question here so I figured I would give too much detail instead of not enough. Also first time poster so be easy :) Setup: In my ""Corporate Buzzwords Bingo"" document I used the following formula to create an array of unduplicated random numbers using the following...
  14. M

    Stop random numbers from changing

    I am trying to create a basic roulette simulation for an assignment, with 5-10000 runs. However, once I have gotten my random numbers, I need then to stop changing. I used the =RANDBETWEEN(0,36), but it changes whenever I change any other cell. Thanks for your help
  15. K

    Generating Test Data in VBA

    ****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 12">****** name="Originator" content="Microsoft Word 12"><link rel="File-List"...
  16. G

    RAND() and permanently capturing the results

    Hi all, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I am currently using “=ROUND(<?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-com:office:smarttags"...
  17. B

    vba random number generator w/weighted averages

    I currently have the following code to generate a random number between the constraints of B9 and B8 (dynamic): Randomize MyValue = Int((Range("B9") - Range("B8")) * Rnd + 0.5) + Range("B8") As it currently is calculated, each number in that range of B8:B9 (ex: 1-4) is weighted equally...
  18. R

    Powerful Histogram Concept!

    I am looking to create a chart detailing the distribution of an equation that has a random number generator as a component. So, the end result would be the above mentioned equation showing a normal distribution curve (or some other distribution curve - not sure yet!!). Here is the catch...

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