Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Every "n'th" Row
How do I set a formula to choose every "n'th" row and extract it to another
spreadsheet? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Every "n'th" Row
On the "other" sheet enter this in A1
=OFFSET(Sheet1!$A$1,10*ROW()-10,0) Drag/copy down as far as you wish. Will return values from row 1, 11, 21, 31, 41 etc. from Sheet1 Adjust to suit. Gord Dibben MS Excel MVP On Thu, 2 Oct 2008 15:33:00 -0700, RyanR8881 wrote: How do I set a formula to choose every "n'th" row and extract it to another spreadsheet? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Every "n'th" Row
"RyanR8881" wrote:
How do I set a formula to choose every "n'th" row and extract it to another spreadsheet? Assume source data in Sheet1, cols A to C, data from row1 down In say Sheet2, you could place this in any start cell, say in B2: =INDEX(Sheet1!A:A,ROWS($1:1)*2-1) Copy B2 across by 3 cols to D2, fill down as far as required to return rows: 1,3,5, ... from Sheet1 And if you wanted to return rows: 2,4,6, ... from Sheet1 instead, use this in the start cell: =INDEX(Sheet1!A:A,ROWS($1:1)*2) Adapt to suit .. -- Max Singapore http://savefile.com/projects/236895 Downloads:18,400 Files:361 Subscribers:58 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Function to find 'n'th largest alphanumeric field (like "Large") | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |