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

describe the development of Mesopotamia
Assume that Thermometer readings are normally distributed with a mean of 0°C and standard deviation of 1.00°C. A Thermometer is randomly selected and tested. Fo
Which food material is used in respiration
Find the GCF of each pair of numbers. 9. 40 and 48 10. 30 and 45 11. 10 and 45 12. 25 and 90 14. 28 and 70 13. 21 and 40 15. 60 and 72 16: 45 and 81 18. 55 and
What did napoleon consider his greatest triumph in domestic policy.
Balance each of the followin skeleton equatios. HCL+Na2CO3=NaCL+H2O+CO2 Al(OH)3+HCL=AlCl3+H2O KSO3=KSO2+O2 C5H12+O2=CO2+h2O C4H10+O2=CO2+H2O C4H9OH+O2=CO2+H2O
Solve the equation. 2(5c – 7) = 1
What are building blocks? Select three options.
Dominique needs to purchase some carrots for a dish she is making tonight. There are no fresh carrots available in produce, so she will buy either frozen or can
Tell whether the sequence is arithmetic. If it is, what is the common difference? (1 point)