Selecting a set of 5 random numbers between 1 and 10, without getting duplicates.
In Data Range (A1:C11):
Enter RAND function in column A:
Enter the following RANK formula in column B:
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