How to capture every 12th value in a column of data

[Guest]

I have a source data worksheet with recurring horizontal tables. Each table represents a week's activity. All activity is rolled into one "Total" number. The Total for each week is 12 rows below the previous week's Total. I want to graph these Total numbers against a Date

I did this manually by creating another worksheet with a summary table of two columns: Date and Total. I can easily create a column of the correct dates, but I have to manually enter the Total value for each week

How can I build a table that automaticaly captures each week's total from the source data worksheet

Thanks
JRG

 

[Max]

Assuming the "Total" cells are in col H in Sheet1,
i.e in H2, H14, H26, H38, etc
(successive "Total"'s are 12 rows below the preceding)

In your summary sheet
---------------------
Assume row1 is for col headers

Put in any cell in row2:

=OFFSET(Sheet1!$H$1,ROW(1:1)*12-11,)

Copy down as many rows
as there are "Total"'s in Sheet1 to be extracted

The above will return the equivalent of:

=Sheet1!$H$2
=Sheet1!$H$14
=Sheet1!$H$26
=Sheet1!$H$38
etc

which are the required extracts you want from the source
Sheet1

Adapt to suit

--
Rgds
Max
xl 97
---
Please respond, in newsgroup
xdemechanik <at>yahoo<dot>com
----

I have a source data worksheet with recurring horizontal

tables. Each table represents a week's activity. All
activity is rolled into one "Total" number. The Total for
each week is 12 rows below the previous week's Total. I
want to graph these Total numbers against a Date.

I did this manually by creating another worksheet with a

summary table of two columns: Date and Total. I can easily
create a column of the correct dates, but I have to
manually enter the Total value for each week.

How can I build a table that automaticaly captures each

week's total from the source data worksheet?