Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Randomly Choose Cells from Colum/Row
hello. i'm not sure if this is possible, but i'm trying to randomly select
multiple cells from a colum to be evaluated. for example, say i have a clumn of 10 cells. i'd like this function in another cell to select 3 cells from the 10 at random. is this possible? thanks |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Randomly Choose Cells from Colum/Row
In a column next to the column containing the ten data items enter:
=RAND() and copy down. Touch F9 and then sort by the newly entered column. This will "randomize" your data. Just take the top three cells. Whenever you want a new sample, repeat the process -- Gary''s Student "J" wrote: hello. i'm not sure if this is possible, but i'm trying to randomly select multiple cells from a colum to be evaluated. for example, say i have a clumn of 10 cells. i'd like this function in another cell to select 3 cells from the 10 at random. is this possible? thanks |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Randomly Choose Cells from Colum/Row
Another variation to try ..
Assume the 10 source items are listed in A1:A10 Put in B1: =RAND() Copy B1 down to B10 Put in C1: =INDEX(A:A,RANK(B1,$B$1:$B$10)) Copy C1 down to C3 C1:C3 will return a random, non-repeating selection of 3 items from within A1:A10 And if you want to random select more than 3 items, just copy C1 down further to C4, C5, .. or all the way to C10 to get the random full scramble of what's in A1:A10 To regenerate a fresh random selection, just press F9 -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "J" wrote in message ... hello. i'm not sure if this is possible, but i'm trying to randomly select multiple cells from a colum to be evaluated. for example, say i have a clumn of 10 cells. i'd like this function in another cell to select 3 cells from the 10 at random. is this possible? thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I randomly shuffle the cells in a column? | Excel Discussion (Misc queries) | |||
REVISED ?? - populate limited cells w/ set value | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Protected cells -automatically format to a different color | Excel Discussion (Misc queries) | |||
copy group of cells to another group of cells using "IF" in third | Excel Worksheet Functions |