random sample

[Guest]

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?

 

[Andy B]

Hi

Alongside your entries, type
=RAND()
and fill down. You can then sort on this random number to randomise your
list.

 

[Peo Sjoblom]

Please refrain from multiposting!

 

[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