| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Selecting random subset of values from one column into another
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Selecting random subset of values from one column into another
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 --------------- Jacob Skaria "Karenne" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting a subset of data from multi columns | Excel Discussion (Misc queries) | |||
| Text to column and selecting values based on a different column | Excel Worksheet Functions | |||
| Text to column and selecting values based on a different column | Excel Worksheet Functions | |||
| Text to column and selecting values based on a different column | Excel Discussion (Misc queries) | |||
| Selecting a subset of items from a list | Excel Worksheet Functions | |||
Linear Mode
