Random sample

Originally Posted by RIROCKHOUND

All;
I have 10 files, each with ~60,000 points.
I want to take a sample of maybe every 10 or 20 points of each file so that I can graph all 10 on the same chart.

any thoughts?

Thanks!
bryan

for each of 10 columns (per file, or per sheet) something like

=INDIRECT("sheet3!A"&ROW()*10-8)

and formula-fill the 10 columns down as far as required (6,500 rows?)

note, the easy way to fill that amount is to

enter the required formula for each column in A1:J1
select A1:J1 and Copy
in the Name box (left of the fx formula bar) type A2:J6500 and press <enter> to select the range
Paste.

the formula shown will give A2, A12, A22, A32 etc.

you can then Chart some of this, note the limitations for Charts include

Data points in a data series for 2-D charts 32,000
Data points in a data series for 3-D charts 4,000
Data points for all data series in one chart 256,000

Does this help?
---