Every Nth data point on a spreadsheet

Possible searches

• "How to Select Every nth Row in Excel?"
• "Select every other row in excel"
• "Select every other cell in excel"
• "Select every other column in excel"
• "Select every other row in a spreadsheet"
• "Select every other cell in a spreadsheet"
• "Select every other column in a spreadsheet"
• "Access every other row in excel"
• "Access every other cell in excel"
• "Access every other column in excel"
  
• "Access every other row in a spreadsheet"
• "Access every other cell in a spreadsheet"
• "Access every other column in a spreadsheet"
  
  

The following pertains to excel versions OLDER than 2007 and iWork Numbers program

Consolidating data

So you've got a massive or complex set of data in a column or row in excel, and you want to grab every other, every third, etc. item. No problem, there's a quick and dirty method. Assuming your desired data is in column A, type the following formula in any cell that is in the same row as the first data value (usually A1, though it could be A2, A3 etc.)

[excel]
=INDEX(A:A, ROW()*2)
[numbers]
=INDEX(A, ROW()*2)

For Excel 2007 some suggested directions can be found at
http://www.lytebyte.com/2009/06/02/how-to-select-every-nth-row-in-excel/
I have not tried these.