Help Please For Formula Copy Skipping Cells?

Originally Posted by Tony Valko

Yeah, that'll work but you can use less sets of ( )...

=IF(AND(OFFSET('Full Survey'!D$1,(ROWS(H$3:H3)-1)*27,0)="SINGLE",OFFSET('Full Survey'!H$14,(ROWS(H$3:H3)-1)*27,0)="IMPROVE"),1,"")

Thank you!

Thanks for your help.