| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to select non-adjacent cells with regular interval
"rickhoff" wrote:
.. select every 4th or 5th cell in that column If source data is in A1 down, to extract every 4th cell in that column Put this in any starting cell desired, say in E2: =INDEX(A:A,ROWS($1:1)*4-3) Copy down as far as required To extract every 5th cell in that column, use: =INDEX(A:A,ROWS($1:1)*5-4) And so on. Adapt to suit. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select filled region only in non-adjacent columns | Excel Discussion (Misc queries) | |||
| Select an item from dropdown list but return value from adjacent c | Excel Discussion (Misc queries) | |||
| How do I Select Multiple Non Adjacent Rows based on a cell value? | Excel Worksheet Functions | |||
| My pivot table does not accept select non-adjacent columns? | Excel Discussion (Misc queries) | |||
| Select a range of non-adjacent cells in Excel? | Excel Worksheet Functions | |||
Threaded Mode
