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

J

JC 550M

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.
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populating entire rows of data from a master sheet? 3
excel formula to copy every Nth value 2
HELP: Adding data from Cells B1, B2, B3 etc. into COL F every other12 rows. 16
How to copy every Nth column to a new sheet 0
How I can set dynamic pivot table ONLY when I have enough data point 1
how can i "transfer data next row every day automatically" in XL 1
How do I display every 5th row of data from a worksheet in a new . 2
How can I create one column (stacked) from a large table of data.. 1

Top