View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] poppiecat5964@gmail.com is offline
external usenet poster
 
Posts: 1
Default 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