Pick 2 numbers randomly from list and iterate

[mrtn88]

Dear all,

I am looking for a way to pick 2 values randomly from a column of 10 values.
The 2 picked values should be copied in a new sheet. Furthermore, the pick-and-copy process should iterate for 1000 or 10,000 times, in order to create a large sample.

Is there anyone who can help me with this problem?

Thanks in advance!
mrtn

[ChemistB]

In Values!A2
=INDEX(returns!$A$2:$A$11,RANDBETWEEN(1,10)) dragged down as far as you need it. Can Value 2 = Value 1? If so, repeat in Column B. You can then copy>paste special>values to remove the formulas (and stabilize the process).