Offset Formula

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
 
R

Ragdyer

One non-volatile way:

=IF(INDEX(D:D,3*ROWS($1:1)+3)=0,INDEX(A:A,3*ROWS($1:1)+3),"")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

nested ifs not enough 1
Formula Discrepancy 2
How to save a PDF with header that extends to edge of page? 3
offset formula causing Circular reference 0
Coppy formula using OFFSET 4
SUM & OFFSET 1
Maintain cell reference after value is moved 1
Copying a Conditional Formatting Formula 2

Top