| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data point on line is not over the point/tick in X axis... | Charts and Charting in Excel | |||
| How to parse data | Excel Discussion (Misc queries) | |||
| How to parse data | Excel Discussion (Misc queries) | |||
| Parse Data to Various Columns | Excel Discussion (Misc queries) | |||
| How to return a specific data point from a large array if I don't know the exact location? | Excel Discussion (Misc queries) | |||
Hybrid Mode
