Nehal413 Nehal413
  • 07-10-2021
  • Computers and Technology
contestada

how to generate random numbers in excel without duplicates

Respuesta :

oloferneshannajilian
oloferneshannajilian oloferneshannajilian
  • 08-10-2021

Answer:

Generate Random Number List With No Duplicates in Excel:

1. Select cell B3 and click on it.

2. Insert the formula: =RANDBETWEEN(10,30)

3. Press enter.

4. Drag the formula down to the other cells in the column by clicking and dragging the little “+” icon at the bottom-right of the cell.

Explanation:

Hope it helps you..

Your welcome in advance..

(ㆁωㆁ)

Answer Link

Otras preguntas

What's the best way to get rid of a cowlick?
7.954 rounded to the nearest hundredths
During the Great Depression, the United States demanded repayment of loans it made to European nations for
Which was one of the reasons Martin Luther wrote his Ninety-five Theses?
what is 10 times as much as in decimal 0.2?
Find the median of 4.5, 7.5, 9, 9, 9.2, 9.3, 10, 10, 10.5 and 13
What's the cube root of 95?
In which of the following is the danger of saltwater intrusion the greatest? A)water supplies near industrial areas B)underground water supplies in farming area
what can 2/16 be simplified by
How did involvement with Europeans in this region change how Americans Indians there lived