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.
Bookmarks