Connect with knowledgeable individuals and find the best answers at IDNLearn.com. Join our community to access reliable and comprehensive responses to your questions from experienced professionals.

how to generate random numbers in excel without duplicates

Sagot :

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..

(ㆁωㆁ)