W
wagergirl
I have a list of 1500 people and I want to get a random sample of 300 people out of the 1500.
Does excel have a formula to do this?
Does excel have a formula to do this?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Andy B
Hi
Alongside your entries, type
=RAND()
and fill down. You can then sort on this random number to randomise your
list.
Alongside your entries, type
=RAND()
and fill down. You can then sort on this random number to randomise your
list.
P
Peo Sjoblom
Please refrain from multiposting!
S
Steve Cross
Select a cell.
From menu toolbar select Insert - Function - RAND().
(This will not work if you just type in the word 'RAND()', it must be
inserted with the 'Function' facility!)
Select that cell and several more cells down the same column.
Press <Ctrl> then <D> keys.
Bingo! It has filled down into all the selected cells.
Evertime you update a cell from now on, all the filled cells will refresh
their values.
Hope this is what you wanted to know.
Steve
From menu toolbar select Insert - Function - RAND().
(This will not work if you just type in the word 'RAND()', it must be
inserted with the 'Function' facility!)
Select that cell and several more cells down the same column.
Press <Ctrl> then <D> keys.
Bingo! It has filled down into all the selected cells.
Evertime you update a cell from now on, all the filled cells will refresh
their values.
Hope this is what you wanted to know.
Steve