Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
randomize set of numbers
Hi!
Column A contains a set of 50, non repeating numbers in random order. Is there a way to have Excel randomly pick 5 of those numbers, not repeating its choosing, and display them across a row beginning in column C? Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
randomize set of numbers
Assuming you have your numbers A1 to A50, you can enter the following
formula in in columns C onwards =INDEX($A$1:$A$50,IF(ROUNDUP(RAND()*50,0)=0,1,ROUN DUP(RAND()*50,0))) With every recalculate event (Press F9) the result will change. -Pramathesh =m justintime wrote: Hi! Column A contains a set of 50, non repeating numbers in random order. Is there a way to have Excel randomly pick 5 of those numbers, not repeating its choosing, and display them across a row beginning in column C? Thanks! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
randomize set of numbers
Hello,
I suggest to use my function UniqRandInt: http://www.sulprobil.com/html/uniqrandint.html HTH, Bernd |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
randomize set of numbers
As they are in random order, just pick the top five.
-- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "justintime" wrote in message Hi! Column A contains a set of 50, non repeating numbers in random order. Is there a way to have Excel randomly pick 5 of those numbers, not repeating its choosing, and display them across a row beginning in column C? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I randomize a set of 496 numbers? | Excel Discussion (Misc queries) | |||
randomize a set of numbers in 1 column that are located in another | Excel Worksheet Functions | |||
Can I randomize numbers ALREADY in a column? | Excel Worksheet Functions | |||
Can I randomize whole numbers in my excel sheet? | Excel Worksheet Functions | |||
randomize | Excel Programming |