ExcelBanter - random numbering

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

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

- - random numbering (https://www.excelbanter.com/excel-worksheet-functions/36132-random-numbering.html)

Gloria

random numbering

Why do I get duplicate numbers when I use the formula for random numbering.

Anne Troy

Because random includes duplicates. If there weren't duplicates, they
wouldn't be "random".
Try this:
http://www.ozgrid.com/VBA/RandomNumbers.htm
*******************
~Anne Troy

www.OfficeArticles.com

"Gloria" wrote in message
...
Why do I get duplicate numbers when I use the formula for random
numbering.

All times are GMT +1. The time now is 06:40 PM.