| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
randomly selection
I need to randomly select 300 entries from a master list of 950 entries.
Ideally I would like to choose every thrid entry. How do I undertake this task? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
randomly selection
Assuming that A2:A100 contains the data...
For every third entry, starting from the first cell in the range: =INDEX($A$2:$A$100,ROWS($B$2:B2)*3-3+1) For every third entry, starting from the 3rd cell in the range: =INDEX($A$2:$A$100,ROWS($B$2:B2)*3) Hope this helps! In article , Shea wrote: I need to randomly select 300 entries from a master list of 950 entries. Ideally I would like to choose every thrid entry. How do I undertake this task? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add "left align across selection" cell formatting | Excel Worksheet Functions | |||
| Insert Picture from dropdown selection | New Users to Excel | |||
| First row in Selection range (first index of a cell) EXCEL VBA | Excel Worksheet Functions | |||
| Max Value in a column exclude selection - Excel VBA | Excel Discussion (Misc queries) | |||
| Cell Selection after "Enter" | Excel Discussion (Misc queries) | |||
Linear Mode
