| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
randomly select numbers
 Hi,Is there a way that I can randomly select two, three or more numbers from a row containing 10 numbers -- jollycarrier ------------------------------------------------------------------------ jollycarrier's Profile: http://www.excelforum.com/member.php...o&userid=37691 View this thread: http://www.excelforum.com/showthread...hreadid=572933 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
randomly select numbers
jollycarrier wrote:
Hi,Is there a way that I can randomly select two, three or more numbers from a row containing 10 numbers Add a help row, put =RAND() in each adjacent cell, select both rows ans sort by the help row, then just select the first 2, 3 cells Regards, Peo Sjoblom |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
randomly select numbers
thanks and you are so smart! -- jollycarrier ------------------------------------------------------------------------ jollycarrier's Profile: http://www.excelforum.com/member.php...o&userid=37691 View this thread: http://www.excelforum.com/showthread...hreadid=572933 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why are 1/2 my numbers imported as text and the rest as numbers? | Excel Discussion (Misc queries) | |||
| how do i create a spread sheet with randomly placed numbers 1-500. | Excel Discussion (Misc queries) | |||
| HOW DO I SELECT ROUND NUMBERS ONLY IN EXCEL SPREADSHEET | Excel Worksheet Functions | |||
| randomly select value WITHOUT changing | Excel Worksheet Functions | |||
| How do I select multiple rows randomly in MS Excel? | Excel Discussion (Misc queries) | |||
Hybrid Mode
