random numbers

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

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

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

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

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

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

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

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

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

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

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

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

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

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

****** 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"...

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"...

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

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