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

How can you make your motor run in reverse? make sure to try it?
Wd-40, inc. markets only one product, its namesake chemical lubricant. the company offers the product in several different container sizes: smaller ones for hou
A member of the classic coltrane quartet, he had a unique piano style based on his use of chords voiced in fourths:
The ipod's entrance into the music player-industry has caused the increased threat of which of the following: threat of substitutes or services for other music
Which colonial leader urged Virginians to prepare for war?
Iram is afraid of snakes. in an effort to help him overcome his fear, his therapist has him enter a room where there are dozens of snakes (non-poisonous, of cou
Which pair of statements correctly compares the two data sets
what is the solution to this question -14x=70
the blank is the soft core of the hair strand
what is the common difference between successive terms in the sequence ?2,8,14,20,26