# random numbers

1. ### 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...
2. ### 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
3. ### 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...
4. ### 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...
5. ### 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...
6. ### 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...
7. ### 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
8. ### 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
9. ### 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...
10. ### 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...
11. ### 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...
12. ### 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
13. ### 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"...
14. ### 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"...
15. ### 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...
16. ### 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...