| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to generate random numbers from a range of cells?
I have a list of 25 differnt numbers in cells from A1 to A25
How can I randomly pick 5 numbers from the range A1:A25 I would like the 5 number to show up in cells C1 to G1 Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to generate random numbers from a range of cells?
Use this in C1:G1... =INDIRECT("A" & INT(RAND()*25)+1) -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "fruitchunk" wrote in message I have a list of 25 differnt numbers in cells from A1 to A25 How can I randomly pick 5 numbers from the range A1:A25 I would like the 5 number to show up in cells C1 to G1 Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to generate random numbers from a range of cells?
create helper column in column B
B1: =RAND() copy down to B25 In C1: =INDEX($A$1:$A$25,RANK(INDIRECT("B"&COLUMNS($C:C)) ,$B$1:$B$25)) copy across to G1 "fruitchunk" wrote: I have a list of 25 differnt numbers in cells from A1 to A25 How can I randomly pick 5 numbers from the range A1:A25 I would like the 5 number to show up in cells C1 to G1 Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to generate random numbers from a range of cells?
Thank to you all!
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Generate random numbers | Excel Discussion (Misc queries) | |||
| Generate Random numbers from a pre-defined set | Excel Worksheet Functions | |||
| Generate Random numbers from a pre-defined set | Excel Worksheet Functions | |||
| How to generate a bunch of random numbers??? | Excel Discussion (Misc queries) | |||
| generate random numbers | Excel Worksheet Functions | |||
Hybrid Mode
