Random number generator

I have a list of 100 numbers(listed from 1 to 100) and I want excel to randomly pick 10 of the numbers. How do I put this into excel?

I don't understand what you said. I want excel to pick 10 random numbers from 1-100.

You could try this.

A1 should be blank. In A2 enter this formula

=LARGE(IF(COUNTIF(A$1:A1,ROW($1:$100))<1, ROW($1:$100)),1+INT(RAND()*(100-ROW()+ROW(A$2))))

confirmed with CTRL+SHIFT+ENTER

copy down to A11

If you press F9 or if worksheet re-calculates, the number are re-generated

Originally Posted by daddylonglegs

You could try this.

A1 should be blank. In A2 enter this formula

=LARGE(IF(COUNTIF(A$1:A1,ROW($1:$100))<1, ROW($1:$100)),1+INT(RAND()*(100-ROW()+ROW(A$2))))

confirmed with CTRL+SHIFT+ENTER

copy down to A11

If you press F9 or if worksheet re-calculates, the number are re-generated

Got to part "copy down to A11"

I pressed F9 and nothing happened. i'm using excel 2003

You need to confirm formula with CTRL+SHIFT+ENTER

This means that you put formula in A2, press F2 key. Hold down CTRL and SHIFT keys and at the same time press ENTER. Curly braces like { and } should appear around the formula in the formula bar. See example attached

try going to data, data analysis, sampling