To generate the unique random numbers in Excel, you need to use two formulas. 1． Suppose you need to generate random numbers without duplicates into column A and column B, now select cell E1, and type this formula =RAND (), then press Enter key, see screenshot: 2. To return the random numbers, duplicates, we will use Rand, Rank and VLOOKUP function along with row function. We use Rand function to select a set of 5 random numbers between 1 and 10, without duplicates. Let’s take an example to understand. We want to return lucky lottery numbers.

Map

(308) 588-1215879

Thank you for contacting us. We will be getting in contact with you shortly.