| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Random Selection
I have a table like this (actually much larger):
Stock Ticker AAPL VAAAH AAPL VAAMH AAPL VAAAJ AAPL VAAMJ AAPL VAAAL AAPL VAAML AAPL VAAAN AAPL VAAMN AAPL VAAAP C C OC C C FC C C RC C C CR C C OR C C FR C C RR C C IE C C UE C C IS C C US C C IF C C UF C C IR C C UR C C ID I would like to create a table like this: Stock Ticker AAPL VAAAJ AAPL VAAMN C C UE C C IE Where the entries in the table represent "N" (in this case 2) randomly selected Stock-Ticker Pairs. I need the table to list out "N" of these selections for each Stock in the original table. So, in the original table there are 2 stocks (AAPL and C) thus the new table has 2 selections for AAPL and 2 selections for C. I hope I explained my problem clearly. Thank you in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Random selection method | Excel Discussion (Misc queries) | |||
| Random Selection | Excel Worksheet Functions | |||
| Random Selection | New Users to Excel | |||
| Random Selection | Excel Worksheet Functions | |||
| How can I set up the random selection of a cell from within a ran. | Excel Discussion (Misc queries) | |||
Threaded Mode
