Selecting a Set of Random Numbers, Avoiding Duplicates


Selecting a set of 5 random numbers between 1 and 10, without getting duplicates.


In Data Range (A1:C11):

Step 1:
Enter RAND function in column A:

Step 2:
Enter the following RANK formula in column B:

Step 3:
Enter the numbers 1-10 in column C.
In Lottery Range (A14:B19):
In column B, use the VLOOKUP and ROW functions in the following formula:
As a result, 5 unique random numbers between 1 and 10 will be displayed in column B.
The numbers will change with each recalculation (press the

One thought on “Selecting a Set of Random Numbers, Avoiding Duplicates

  1. Please show how to create a Random Number Genertor for 10 columns each labeled for a month with 350 rows. The result is create a number that will be associated to another spreadsheet grid number equated to an inventory storage location. The intent is to do 10% invtory per month without duplication of inventory locations.

Leave a Reply

Your email address will not be published. Required fields are marked *

3 × six =

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>