Drag down formula to skip 2 rows.

[StudioLETA]

All,

I have the following formula in cell 'Employee' B5: =IF(OFFSET('Detailed Hours'!$B$3,ROW(B3)-1,0)=0,"",OFFSET('Detailed Hours'!$B$3,ROW(B3)-1,0))

I would like to be able to drag it down so that cell B6 is empty and then cell B7 reads :=IF(OFFSET('Detailed Hours'!$B$3,ROW(B4)-1,0)=0,"",OFFSET('Detailed Hours'!$B$3,ROW(B4)-1,0))

I've been playing around trying to insert the INDEX function or change the OFFSET variables, but I cant seem to figure it out because I do not fully understand how they work.

Thank you for your time.

[samba_ravi]

Please attach sample file

[MarvinP]

Try this,

Replace the Row(B4) with INDIRECT("B"&(ROW()+1)/2)

[StudioLETA]

Please find a example spreadsheet attached. Let me know if I need to describe more.

[StudioLETA]

MarvinP, this is what I did, but it did not seem to work.

=IF(OFFSET('Detailed Hours'!$B$3,INDIRECT("B"&(ROW()+1)/2),0)=0,"",OFFSET('Detailed Hours'!$B$3,INDIRECT("B"&(ROW()+1)/2),0))

[StudioLETA]

MarvinP, this is what I did, but it did not seem to work.

=IF(OFFSET('Detailed Hours'!$B$3,INDIRECT("B"&(ROW()+1)/2),0)=0,"",OFFSET('Detailed Hours'!$B$3,INDIRECT("B"&(ROW()+1)/2),0))

[samba_ravi]

A5=IF(MOD(ROW(A1),2)=0,"",OFFSET('Detailed Hours'!A$5,INT((ROW(A1)-1)/2),0))
Try this in "Employee" Sheet and copy across

[StudioLETA]

nflsales, works perfectly, thank you!