# How To Generate Random Numbers In Range 1:20 With Unique Results

Mar 22, 2014
In an earlier life I was tasked with finding a "random" method of selecting two numbers from a "1 to 20" range so that the generated numbers can be applied to an set of people who will be partnered in a golf game draw.

It is only one draw per year so I don't care if the players have previously played together in past years.

easily be modified by a "passable knowledge level" person to be able to select a mystery "9" out of 18 holes that count for scores that particular round.

(btw: this is an issue only for the 20 guys who go away once a year to play golf, the world will not collapse if I have to draw numbers out of a hat, just looking for a slightly more elegant solution and I already have a few scoring macros so my first guess (but not only possibility) is VBA)

View 8 Replies
ADVERTISEMENT
Oct 7, 2005

I want to generate numbers (1 to 15) in cells A1 through O1, but the

number in each cells should be unique compare to the other cells, how

can I do it? If I use =randbetween(1,15), I can not get unique number

in each cell, some numbers are duplicated.

View 11 Replies
View Related
Feb 9, 2014

How to create a sheet to generate Random numbers from 2 specific list of a main list range of 36 Numbers. (List A = Specific 15 numbers, List B = The remaining Numbers from these 36)

Example :

-The Main List Range is from Number 01 to 36

-The Specific random list will be 15 Numbers of these 36

List A-. The Specific 15 Numbers are: 01,02,03,10,11,12,13,20,21,22,23,30,31,32,33

List B-. Remaining Numbers : 04,05,06,07,08,09,14,15,16,17,18,19,24,25,26,27,28,29,34,35,36

So

I need to generate ONE Unique Random Numbers of List A ( 01,02,03,10,11,12,13,20,21,22,23,30,31,32,33)

In Cell A1

In Cell A2

In Cell A3

And from List B, (04,05,06,07,08,09,14,15,16,17,18,19,24,25,26,27,28,29,34,35,36)

I need to do the same thing In

Cell A4

Cell A5

Cell A6

It's possible to have a 6 cells with random but Unique Digits? (not repeated numbers between the 6 cell ??)

View 2 Replies
View Related
Dec 12, 2007

I need to generate random numbers in the selected range. I've looked at quite a few posts on the topic of random numbers, but I can't find one that will fill the selected range with numbers.

View 9 Replies
View Related
Sep 18, 2009

I am working on a Random Cycle Count Generator that provides random SKU#s based on 3 separate columns of SKU listings. The user clicks a button to generate the SKU#s to cycle count for that day. What I would like to see is a date stamp in the columns next(B,D,F) to the referenced SKU listing(A,C,E) based on which SKU#s are generated. This will let me see the last date that the SKU was generated. I would also like it to automatically save after generating.

View 2 Replies
View Related
Jul 18, 2012

How do I create a 6 digit unique random number for use as an ID in column A. Once created the rows with preexisting 6 digit unique random ID numbers must not change every time new rows are added.

View 9 Replies
View Related
Aug 19, 2014

I am creating an excel spread sheet for a project I am doing, I need to create a daily chart for 6 months of water usage that results in averaging set targets.

I have made a chart with the average uses per day but would like to have daily numbers that average out to what i have but in a random sequence e.g. i have that a shower uses 320 litres per day for 2 people is there a way i can make a chart that says: 300 (a1) 340(a2) 260(a3) 360(a4) etc i need to do this for 180 days with random numbers generated to average the same overall. I dont know even how to generate random numbers.

View 4 Replies
View Related
Feb 1, 2009

I am trying to generate random numbers between 0 - 9 in ten cells that do not repeat an always include every value 0 - 9 (0, 1, 2, 3, 4,...9). The object is to have the numbers randomize each time. So cells A1:A10 could look like this:

3

9

4

5

1

0

6

8

7

2

Or, they could look like this:

9

7

5

2

8

4.................

View 4 Replies
View Related
May 14, 2014

generate 100 random numbers between 100 and 300 in some range of cells like A1:j10

View 1 Replies
View Related
Aug 24, 2014

Any way/method to make a certain number of cells randomly generate to a specific value you want? I only want to use the number from 1 to 60.

example:

1 37

2 29

3 34

4 2

5 58

6 38

7 =198

View 9 Replies
View Related
May 23, 2013

How do I use RAND to generate random numbers between 0.25 & 0.5?

View 9 Replies
View Related
Mar 17, 2008

I'm trying to generate a dataset to use as an example in a class I'm helping out with.

I want 75 cases (that is, 75 rows)

Column A

randomly pick 1 or 2

Column B

60% 1 and 40% 2 randomly assigned to cases 1-75 (Thus, 45 1's and 30 2's randomly assigned to rows 1-75)

Column C

Randomly pick from the range of numbers 18-65. Make sure the mean for the column is 48.72.

Column D

Randomly pick from the range of numbers 1-7. Make sure the mean for the column is 5.49.

View 9 Replies
View Related
Feb 24, 2008

I've got a problem with creating random numbers for a fictional portfolio. I've to have a row of random number but they have to add up to 1. Example: Need random numbers from B1-B11

under constraint: Sum(B1-B11) = 1

I tried to do it with the solver addin, but it only takes simple numbers as a constraint.

View 4 Replies
View Related
Jun 21, 2007

I have a frequency list (frequency per year) resulted from previous calculation. What I want is to generate random number as many as the frequency in the specified year, so that every year I will get the same amount of random numbers as the frequency. It is kind of the opposite of FREQUENCY function (but with random numbers involved). I need to use the result for further calculation.

View 11 Replies
View Related
Feb 25, 2009

I am trying to generate random numbers with the the constraint that the maximum value is 40 and the most likely value is around 40% of the maximum value. Are there any distributions (lognormal??) that would suit this requirement? Is there any way I can do this in Excel?

View 3 Replies
View Related
May 31, 2014

I have a userform for keeping records and would love to incorporate a new feature. I would want to generate a random serial number for each entry made with the userform.

View 2 Replies
View Related
Feb 25, 2009

I've been using excel for quite sometime but have never tried the macro system or posting VBA code so I'm wanting to get my feet wet with a little project.

I want to make a button on a sheet that when pressed generates a random number between 3 and 18, ideally it would make a new set of random numbers if pressed again.

View 12 Replies
View Related
Dec 7, 2013

How to generate all the possible combinations of 5 numbers, e.g. 1,2,3,4,5. Then 2,3,4,5,1 and so on, in a series of excel columns and rows. Also for 6 numbers etc.

View 14 Replies
View Related
Mar 7, 2009

I want to add & generate unique numbers in a column of similiar words..

For Instance:

RED

RED

RED

BLUE

BLUE

BLUE

etc..etc..

I want it to look like this:

RED1

RED2

RED3

RED4

RED5

BLUE1

BLUE2

BLUE3

I want infinite numbers next to the same wording but unique.

I have 2 rows A & B.. NAME & MOBILE PHONE Title in line 1

I am not to familiar with excel. Step by Step please, anyone out there.

I saw a similar posting, but the formula did not work out for me.

Then i am going to save the file as a CSV

View 3 Replies
View Related
Feb 19, 2008

I have 12 Cells, years 1 to 12. I want to create a random number for each cell, which then depending on what the number is, either 1-75 being 8,000,000 or 76-100 being 10,500,000, place it in the cell and be able copy it down. What i have done already you can see on the attached workbook, or the table i used:

I used this table to generate the random number to give either 8m or 10.5m, except i put the VLOOKUP in the year 1 cell, added some dollars signs and copied down but that only makes them all the same, so i want a way to make each year have its own random number preferably without making 10 tables.

View 3 Replies
View Related
Jun 27, 2009

I need a macros to fill 2000 rows with unique random numbers from 1 to 19 in B2:T2001 area. Every row like this

14 11 12 7 18 13 19 5 6 16 9 4 8 15 1 3 10 2 17

Actually it's about random positions in rows for numbers from 1 to 19.

View 3 Replies
View Related
Dec 14, 2006

I have a list numbered 0 to 300. What I am looking for is a formula to randomly select 150 unique sets of two numbers and list them in separate columns for a competition draw and should appear as per the example below

HomeAway

7v96

11v4

146v25

View 4 Replies
View Related
Mar 17, 2008

I am looking for a way to create a random order of numbers in a given range. For example, A1:a100 to be populated with a random number between 1 and 100, but not to duplicate, using every possible number within that range. I use the RANDBETWEEN function to generate the numbers, but I cannot prvent them from duplicating.

View 2 Replies
View Related
Mar 18, 2013

I've read a lot of tutorials on how to use pivot tables, but found them either too basic, or too advanced, and never finding any example of what I am looking to do.

I have a database, column A holds names, and column B their phone numbers. I'd like to generate a list of unique names and their associated telephone numbers. I figure I can use a pivot table to do this.

But I do not quite understand how to format the pivot table to put the name in one column and the phone number in the next. I will use this pivot table as a vlookup range. I assume I can do this.

View 7 Replies
View Related
Jul 18, 2014

The two boxes up top will be my start and stop numbers. I want to generate all the numbers between (and including) the 'start' and 'stop' numbers in the top two boxes above using VBA and list them in the larger text box below (I've changed the background of the textbox to appear as it was a label, fyi).

View 9 Replies
View Related
Aug 29, 2007

i modify the result but the problem is that when i try it the result alway have a higher number i cannot have a low number...

i want to have the reult from 1 to 1899

here is the

Private Sub CommandButton1_Click()

Randomize

TextBox1.Value = Int(Rnd * 1)

TextBox2.Value = Int(Rnd * 9) + 1

TextBox3.Value = Int(Rnd * 9) + 1

TextBox4.Value = Int(Rnd * 9) + 1

End Sub

Private Sub TextBox1_Change()

End Sub

Private Sub TextBox2_Change()

End Sub

Private Sub TextBox3_Change()

End Sub

View 5 Replies
View Related
Sep 26, 2009

I was just wondering if there is a way to make rand or randbetween functions work with text. Alternatively, is there another function that will allow me to do this, without adding numbers in the parallel row.

I want the column, to randomly choose between "male" and "female". I do not want to add additional rows or columns preferably..

View 14 Replies
View Related
Jan 3, 2014

Is it possible to use the =randbetween() function to generate a random number between 0.8 and 1.2.

View 4 Replies
View Related
Oct 11, 2007

is if there is a way to generate random numbers between 0001 and 9999. I always need to always have 4 digits. The first couple of numbers can be 0 so that I can maximize the number of variations.

View 9 Replies
View Related
Oct 22, 2008

I want excel to generate a random integer between 132 and 321 and place it into cell B10. What formula would I need to enter into cel B10 to do this

View 9 Replies
View Related