Hi,

Assuming that the data start at A2 in Sheet1, and that you want to extract
every 3rd row of that sheet into a new sheet, enter the following formula in
A2 of the new sheet:

=OFFSET(Sheet1!$A$2,(ROW()-ROW($A$2))*3,COLUMN()-1)

If the original data start at a cell other than A2 in Sheet1, or if you want
the extracted data to start at a different cell (not A2) in the new sheet,
modify the formula accordingly.

Drag the formula across the columns by as many columns as there are in the
original sheet, and down the rows by about 1/3rd as many rows as there are in
the original sheet. If you go beyond, the formula will create blocks of
zeros that you may easily delete.

Regards,
B. R. Ramachandran



"debbiemc" wrote:

I am trying to find a way for a formula to select and extract every 3rd line
or record.
--
Debbie Mc.