how do i parse every nth data point from a large data set in exce
 

I work with very large data sets imported into Excel. I want to reduce the
data from over 60,000 data points to 6000 by selecting every 10th data point.
So for example I have 10 colums of 60,000 (rows) data that I want to get 1
data point for every 10 lines.

how do i parse every nth data point from a large data set in exce
 

In a helper column on another sheet.............

=INDIRECT("Sheet1!A"&ROW()*10)


Gord Dibben MS Excel MVP

On Mon, 2 Nov 2009 12:28:01 -0800, JC 550M <JC
wrote:

I work with very large data sets imported into Excel. I want to reduce the
data from over 60,000 data points to 6000 by selecting every 10th data point.
So for example I have 10 colums of 60,000 (rows) data that I want to get 1
data point for every 10 lines.