ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   If I create a random list in Excel, does it repeat numbers? (https://www.excelbanter.com/excel-worksheet-functions/19716-if-i-create-random-list-excel-does-repeat-numbers.html)

Kelly

If I create a random list in Excel, does it repeat numbers?
 


Harald Staff

Yes.
But not too often.
Sometimes never.

HTH. Best wishes Harald



RagDyer

True random means just that ... *ANY* number can come up, and sometimes its
a duplicate of what came up before.

However, you can create a specific set of numbers, and then display them in
random *order*.
That eliminates the possibility of duplicates.

If you're interested in such a procedure, post back with some particulars
.... BUT use the body of the message, not just the subjet line.
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

"Kelly" wrote in message
...



All times are GMT +1. The time now is 11:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com