Data list
 

I have a list of data that I am trying to summarize in a separate worksheet.
My formula in cell A3= Master!A2. In cell A4 I have the formula = Master!A14
(or 12 rows down). Cell A5= Master!A26 etc. down the entire sheet. I have
manually put in A14, A26, etc. down the column.

How can I automate that formula to say I would like whatever is 12 rows down
from the cell above it? So, in cell A4, I don't want to manually put in A14
but tell it to look 12 rows down from A3.

Does that make sense?

You can use the INDIRECT function. In cell A3, enter:

=INDIRECT("Master!A"&2+(ROW()-3)*12)

and copy down as far as required.

HJ wrote:
I have a list of data that I am trying to summarize in a separate worksheet.
My formula in cell A3= Master!A2. In cell A4 I have the formula = Master!A14
(or 12 rows down). Cell A5= Master!A26 etc. down the entire sheet. I have
manually put in A14, A26, etc. down the column.

How can I automate that formula to say I would like whatever is 12 rows down
from the cell above it? So, in cell A4, I don't want to manually put in A14
but tell it to look 12 rows down from A3.

Does that make sense?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thanks so much :)

"Debra Dalgleish" wrote:

You can use the INDIRECT function. In cell A3, enter:

=INDIRECT("Master!A"&2+(ROW()-3)*12)

and copy down as far as required.

HJ wrote:
I have a list of data that I am trying to summarize in a separate worksheet.
My formula in cell A3= Master!A2. In cell A4 I have the formula = Master!A14
(or 12 rows down). Cell A5= Master!A26 etc. down the entire sheet. I have
manually put in A14, A26, etc. down the column.

How can I automate that formula to say I would like whatever is 12 rows down
from the cell above it? So, in cell A4, I don't want to manually put in A14
but tell it to look 12 rows down from A3.

Does that make sense?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html