| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Randomly Choose Two Numbers | Excel Discussion (Misc queries) | |||
| randomly select numbers | Excel Discussion (Misc queries) | |||
| to find missing serial numbers in randomly generated numbers | Excel Worksheet Functions | |||
| Can the computer be set to randomly select a row for a drawing? | Excel Discussion (Misc queries) | |||
| Randomly Sort a Series of Numbers | Excel Discussion (Misc queries) | |||
Linear Mode
