ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   non repeating Random number generation (https://www.excelbanter.com/excel-worksheet-functions/450246-re-non-repeating-random-number-generation.html)

[email protected]

non repeating Random number generation
 
On Thursday, March 13, 2003 2:00:54 PM UTC, Ken Dordi wrote:
I want to be able to produce 49 non repeating random
numbers chosen from 1 to 49 so that all 49 numbers are
randomly jumbled but there are no two numbers the same.
yes you guessed its for a lottery worksheet im trying to
compile, if someone out there has an excel worksheet which
does this id be very grateful.


Saddo I'm sure you're time will come when you can pick any number you want


All times are GMT +1. The time now is 12:07 AM.

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