Data list

[Guest]

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]

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

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

and copy down as far as required.

 

[Guest]

Thanks so much

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

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

and copy down as far as required.