Copy a formula pattern

[JPreeshl]

I am trying to copy a formula that pertains to another sheet in the same
workbook. How can I do this?
=IF(I1="","",'Team Winners'!$AB7)
=IF(I2="","",'Team Winners'!$AB7)
=IF(I3="","",'Team Winners'!$AB7)
=IF(I4="","",'Team Winners'!$AB8)
=IF(I5="","",'Team Winners'!$AB8)
=IF(I6="","",'Team Winners'!$AB8)
Every third row I need to increase the row by one. If I just do a copy every
row goes up by one. I need to do this down to row 165.

 

[Luke M]

You can do this:

=IF(I1="","",INDIRECT("'Team Winners'!AB"&INT(ROW(A3)/3)+6))

or

=IF(I1="","",OFFSET($AB7,INT(ROW(A3)/3)-1,)

The latter being prefered if there's the possibility of cell AB7 being moved
around due to cutting/inserting of rows/columns.

 

[T. Valko]

=IF(I1="","",INDIRECT("'Team Winners'!AB"&INT(ROW(A3)/3)+6))

That one works

=IF(I1="","",OFFSET($AB7,INT(ROW(A3)/3)-1,)

That one is missing a closing ) but it doesn't work.

Another one...

Assume you want the results starting in cell AC1 and copied down:

=IF(I1="","",INDEX(AB$7:AB$100,CEILING(ROWS(AC$1:AC1)/3,1)))

Adjust for the correct end of range AB100.