From the spreadsheet(SS-1) below I would like to copy the data from every
third line (COL-1, COL-4,COL-5) into another spreadsheet(SS-2). In SS-1
COL-4 & COL-5 are the average of the three entries in COL-2 & COL-3. I tried
to enter the formulas in the first row of SS-2, then copy them down to the
bottom of the SS, but since I only want data from every third linne in SS-1,
the formulas don't copy like I want. I even used a macro to delete all but
every third row in SS-2, but that seems rather awkward.

Any suggestions?
k1ngr
=====================================
(SS-1)
COL-1 COL-2 COL-3 COL-4 COL-5
1/1/08 140 80
1/1/08 130 85
1/1/08 120 90 130 85
1/5/08 112 72
1/5/08 117 73
1/5/08 111 79 113 75
=====================================
(SS-2)
COL-1 COL-2 COL-3
1/1/08 130 85
1/5/08 113 75
=====================================

Assume data as posted in sheet: SS-1
starts in row1 down

In SS-2,
Place in B1:
=OFFSET('SS-1'!$C$3,ROWS($1:1)*3-3,COLUMNS($A:A))
Copy B1 to C1, fill down to return the required results
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"k1ngr" wrote:
From the spreadsheet(SS-1) below I would like to copy the data from every
third line (COL-1, COL-4,COL-5) into another spreadsheet(SS-2). In SS-1
COL-4 & COL-5 are the average of the three entries in COL-2 & COL-3. I tried
to enter the formulas in the first row of SS-2, then copy them down to the
bottom of the SS, but since I only want data from every third linne in SS-1,
the formulas don't copy like I want. I even used a macro to delete all but
every third row in SS-2, but that seems rather awkward.

Any suggestions?
k1ngr
=====================================
(SS-1)
COL-1 COL-2 COL-3 COL-4 COL-5
1/1/08 140 80
1/1/08 130 85
1/1/08 120 90 130 85
1/5/08 112 72
1/5/08 117 73
1/5/08 111 79 113 75
=====================================
(SS-2)
COL-1 COL-2 COL-3
1/1/08 130 85
1/5/08 113 75
=====================================

Try Pivot Table.
No formulas needed in either sheet.
Source data can be located anywhere on sheet.
Number of items for each date can be variable.
Data can be entered out of order.
http://www.freefilehosting.net/download/3bahh