S
Sean
I have the formula =IF(D6=0,A6,"") in D150. How can I use the Offset
feature so that in D151 the following formula would appear
=IF(D9=0,A9,"") etc etc in D152, D153
I just cannot get my head around Offset feature
Thanks
feature so that in D151 the following formula would appear
=IF(D9=0,A9,"") etc etc in D152, D153
I just cannot get my head around Offset feature
Thanks
,3*ROWS($1:1)+3)=0,INDEX(A:A,3*ROWS($1:1)+3),"")