Copy a formula pattern
 

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.

Copy a formula pattern
 

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.


--
Best Regards,

Luke M
"JPreeshl" wrote in message
...
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.