| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can i randomly select 780 rows from 4000 rows of data
In Excel i have a spreadsheet with 4000 rows of data and would like to
randomly select a list of 780 rows showing only one cell of the data? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can i randomly select 780 rows from 4000 rows of data
bbb,
Randomly selecting 780 of 4000 rows is simple enough but can you explain what you mean by ".....showing only one cell of data?" Mike "bbb" wrote: In Excel i have a spreadsheet with 4000 rows of data and would like to randomly select a list of 780 rows showing only one cell of the data? |
|
#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 |
| Reply |
| 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) | |||
Hybrid Mode
