Function that spans over rows with a jump

[bjornlindholm]

Hey!

I have a function, IF('Flik 2'!A2<>"XXXX-YY";'Flik 2'!A2;"XXXX-YY"), this is written in the cell A65, i want the next cell with the formula to be A72, and the formula should be
IF('Flik 2'!A6<>"XXXX-YY";'Flik 2'!A&;"XXXX-YY"). I should say that cell A65-A71 are merged cells and also A72-A78, the formula should be insterted in every merged cell down to cell A548, and it should increase with 4 everytime. I hope you understand my problem!

Thanks in advance!

 

[steve the fish]

Isnt this:

IF('Flik 2'!A2<>"XXXX-YY";'Flik 2'!A2;"XXXX-YY")

just

'Flik 2'!A2

Whats the point of the IF?

 

[bjornlindholm]

Isnt this:

IF('Flik 2'!A2<>"XXXX-YY";'Flik 2'!A2;"XXXX-YY")

just

'Flik 2'!A2

Whats the point of the IF?

Because when Flik 2! A2 shows nothing then the cells should show XXXX-YY

 

[steve the fish]

Try like this:

=IF(INDEX('Flik 2'!A:A,(ROWS($A$1:A1)-1)/7*4+2)="","XXXX-YY",INDEX('Flik 2'!A:A,(ROWS($A$1:A1)-1)/7*4+2))

change the separators to match yours.

 

[bjornlindholm]

Thanks!