Referencing cells in consecutive rows

[PVermillion]

Hello, this is my first post to the forum and I am hoping someone would
be willing to offer some advice...

This is a difficult question for me to put into words but I am trying to
find a way to reference a cell on another sheet in two consecutive rows
and then skip to the next row.

Here is an example and what I am looking for:

=Sheet1!A1
=Sheet1!A1
=Sheet1!A2
=Sheet1!A2
=Sheet1!A3... etc, etc.

I am currently using an absolute reference, copying it down 3 cells,
then manually changing the last cell to reference the next in line. Is
there a faster way to do this? I have to do this hundreds of times and
it would be a real timesaver.

Thank you in advance!

 

[Claus Busch]

Hi,

Am Wed, 10 Jul 2013 16:31:00 +0100 schrieb PVermillion:

=Sheet1!A1
=Sheet1!A1
=Sheet1!A2
=Sheet1!A2
=Sheet1!A3... etc, etc.

try:
=INDIRECT("Sheet1!A"&ROUNDUP(ROW(A1)/2,0))


Regards
Claus B.

 

[PVermillion]

This is exactly what I was looking for! Thank you very much!