Selecting random subset of values from one column into another

[Karenne]

Hi. Hoping that someone can help me with this query.....

I have a column with 100 values. I would like to create another column with
30 values selected randomly from the 1st column of 100 values. Is there a
formula i can use to do this?

Thanks!

Karenne Tun

 

[Jacob Skaria]

Hi Karenne

With your data in Col A A1 to A100

--In B1 enter the below formula and copy down upto B100
=RAND()

--In C1 enter the below formula and copy down to C30 (your sample list)
=INDEX($A$1:$A$100,RANK(B1,$B$1:$B$100))


If this post helps click Yes