Select Every Other Row

[Zorba0032]

Good Day Everyone!

I deal with large amounts of data from datalogs. I receive these logs in .CSV files with a snapshot of maybe 100 data points every 10 seconds. So when I pull data for a 24 hour period I may have over 140k data points to review and chart.

I am looking for a sensible way to be able to parse every third or forth line of code to reduce the amount of data. I was also playing with a way to write a macro to pick one data point for a selectable time. Such as one data point per hour or two data points per hour.

I have to be honest and say I have failed quite miserably.

A push into the correct direction would be appreciated. I certainly appreciate any assistance that can be given.

Thank you!

 

[Toadstool]

Hi Zorba0032,

You could build a new list from the subset.

Zorba0032.xlsx
	A	B	C	D	E
1	Data		Interval		Result
2	X000002		4		X000004
3	X000003				X000008
4	X000004		Entries A		X000012
5	X000005		140375		X000016
6	X000006				X000020
7	X000007				X000024
8	X000008				X000028
9	X000009				X000032
10	X000010				X000036
11	X000011				X000040
Sheet1

Cell Formulas
Range	Formula
C5	C5	=COUNTA($A:$A)-1
E2:E11	E2	=IF(INT((ROW()-1)*$C$2)>$C$5,"",INDEX($A:$A,INT((ROW()-1)*$C$2)))

 

[Peter_SSs]

Welcome to the MrExcel board!

Same concept as Toadstool's but because you have MS 365 you can do something similar with a single formula in a single cell.

Zorba0032.xlsm
	A	B	C	D	E
1	Data		Interval		Result
2	X000002		4		X000002
3	X000003				X000006
4	X000004		Entries A		X000010
5	X000005		68470		X000014
6	X000006				X000018
7	X000007				X000022
8	X000008				X000026
9	X000009				X000030
10	X000010				X000034
11	X000011				X000038
Sheet1

Cell Formulas
Range	Formula
E2:E17118	E2	=INDEX(A:A,SEQUENCE(C5/C2,,2,C2))
C5	C5	=COUNTA($A:$A)-1
Dynamic array formulas.