ExcelBanter - Random Numbers

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Random Numbers (https://www.excelbanter.com/excel-worksheet-functions/75981-random-numbers.html)

Terence

Random Numbers

I would like to create 30 random numbers in cells A1 to A30 that are between
1 and 2000, and I do not want duplicates. For example, I don't want cells A5
and A22 to return 1752.

Niek Otten

Random Numbers

http://www.tushar-mehta.com/excel/ne...ion/index.html

--
Kind regards,

Niek Otten

"Terence" wrote in message
...
I would like to create 30 random numbers in cells A1 to A30 that are
between
1 and 2000, and I do not want duplicates. For example, I don't want cells
A5
and A22 to return 1752.

All times are GMT +1. The time now is 07:10 PM.