can i put in numbers and have the computer randomly draw 1?how?
I would like to know if there is any way to create a lottery but with numbers
I have chosen already. I have 8 five digit numbers and I want to have the computer randomly draw three every week. |
can i put in numbers and have the computer randomly draw 1?how?
Hi,
If iv'e inderstood correctly put your eight numbers in A1 - A8 Put this in B1 and drag down =Rand() select both columns and sort by column B. Pick the top 3 numbers Tap F9 and sort again to get a different 3 Mike "Slopez" wrote: I would like to know if there is any way to create a lottery but with numbers I have chosen already. I have 8 five digit numbers and I want to have the computer randomly draw three every week. |
All times are GMT +1. The time now is 03:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com