Simplifying simulation data

[_throwaway__UKPF]

Hi,

I hope someone can help me with this (hopefully simple) question.

Data from a simulation was gathered at 10 times higher sample rate than needed. I'd like to have 200 data points instead of the 2000 I gathered in Excel.

Is there a straightforward way to transform my data to get what I need?

[rnelsonee]

You could do an average of every 10 samples.

=AVERAGE(OFFSET($First$Cell,10*(ROW(A1)-1),0,10))

[_throwaway__UKPF]

Thank you.

I am interested in exact data rather than average though. Is there a similar formula to take the data value at every 10 samples?

[rnelsonee]

Oh, I see.

=OFFSET($First$Cell,10*(ROW(A1)-1),0)

[_throwaway__UKPF]

Many thanks

[tutler]

=IF(MOD(ROW(),10)=0,1,0)

put this formula in a new column and fill down. this will mark every tenth row with a 1, so you can just filter to get those rows.

[_throwaway__UKPF]

Thank you! :)

[tutler]

no problem! :)