| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can i randomly select 780 rows from 4000 rows of data
Hello,
If your 4000 rows are in Sheet1 (rows 1 to 4000) then switch to Sheet2 and: 1. Select A1:A780 2. Array-enter =INDEX(Sheet1!A1:A4000,UniqRandInt(4000)) (enter with CTRL + SHIFT + ENTER, not only ENTER) My macro UniqRandInt you can get he http://www.sulprobil.com/html/uniqrandint.html Regards, Bernd |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select certain data rows | New Users to Excel | |||
| Sometimes data will jump rows randomly. | Excel Discussion (Misc queries) | |||
| Is there a way to randomly select rows in Excel? | Excel Discussion (Misc queries) | |||
| How do I select multiple rows randomly in MS Excel? | Excel Discussion (Misc queries) | |||
| Unable to select rows in the repeat rows on top option | Excel Discussion (Misc queries) | |||
Threaded Mode
