| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I randomize digits in Excell?
For example: I have a row of 6 digits, number 1 to 6, which I want to
randomize over 30 trials... how can i do this? I'm working with micr. excell 2003. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I randomize digits in Excell?
Try this (to be copied in a 30x6 range):
=INDEX($A$1:$F$1,1,INT(RAND()*6)+1) HTH -- AP "An" a écrit dans le message de news: ... For example: I have a row of 6 digits, number 1 to 6, which I want to randomize over 30 trials... how can i do this? I'm working with micr. excell 2003. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| maximum number size/significant digits | Excel Discussion (Misc queries) | |||
| Mistery digits on excel | Excel Discussion (Misc queries) | |||
| excel floating digits error | Excel Discussion (Misc queries) | |||
| how do i stop excell from turning the last five digits in a 20 di. | Excel Discussion (Misc queries) | |||
| lable ranges in Excell | Excel Discussion (Misc queries) | |||
Linear Mode
