A Sampling Program
 

Is there existing macros or functions that I can perform the following
sampling logic?

I have a file with 500K transactions. Would like to start with a number and
select one transaction every 30 records. The total number of selected
transactions are 2000.

Thanks.

A Sampling Program
 

Response below posted to your multi-post in .worksheet.functions
(Pl refrain from multi-posting)
------
One way ..

Assume txn data is in col A, from A1 down to A65536

In B1 will be input the row start number, say: 3

Put in C1: =OFFSET(INDIRECT("A"&$B$1),ROW(A1)*30-30,)
Copy C1 down to C2000

C1:C2000 will return what's in: A3, A33, A63, ....
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Miloann" wrote in message
...
Is there existing macros or functions that I can perform the following
sampling logic?

I have a file with 500K transactions. Would like to start with a number
and
select one transaction every 30 records. The total number of selected
transactions are 2000.

Thanks.

A Sampling Program
 

Had presumed there was a typo (an extra zero?) in your line:
I have a file with 500K transactions.
(50K, not 500K <g)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---