software

Hi Group,
I have 2 sheets. One called WORKSHEET one called REPORT.

In the report sheet I want to copy a formula down the page so

that the referenced cells increment by 12 instead of 1 as per

below.
C18 =IF(WORKSHEET!C10=0,quot;quot;,WORKSHEET!C12)

C19 =IF(WORKSHEET!C22=0,quot;quot;,WORKSHEET!C24)

C20 =IF(WORKSHEET!C34=0,quot;quot;,WORKSHEET!C36)
I feel like this should be very simple but I just can't work it out,

Any help would be much appreciated.
Hi!

Try this:

=IF(OFFSET(WorkSheet!C$10,(ROWS($1:1)-1)*12,,)=quot;quot;,quot;quot;,OFFSET(WorkSheet!C$12,(ROWS($1:1)-1)*12,,))

Biff

quot;MartinWquot; gt; wrote in message
...
gt; Hi Group,
gt;
gt;
gt;
gt; I have 2 sheets. One called WORKSHEET one called REPORT.
gt;
gt; In the report sheet I want to copy a formula down the page so
gt;
gt; that the referenced cells increment by 12 instead of 1 as per
gt;
gt; below.
gt;
gt;
gt;
gt; C18 =IF(WORKSHEET!C10=0,quot;quot;,WORKSHEET!C12)
gt;
gt; C19 =IF(WORKSHEET!C22=0,quot;quot;,WORKSHEET!C24)
gt;
gt; C20 =IF(WORKSHEET!C34=0,quot;quot;,WORKSHEET!C36)
gt;
gt;
gt;
gt; I feel like this should be very simple but I just can't work it out,
gt;
gt; Any help would be much appreciated.
gt;
Oops!

You were testing for 0 and I wrote the formula testing for blank!

Just change =quot;quot; to =0.

An empty cell evaluates to 0 so the formula will still return blank.

Biff

quot;Biffquot; gt; wrote in message
.. .
gt; Hi!
gt;
gt; Try this:
gt;
gt; =IF(OFFSET(WorkSheet!C$10,(ROWS($1:1)-1)*12,,)=quot;quot;,quot;quot;,OFFSET(WorkSheet!C$12,(ROWS($1:1)-1)*12,,))
gt;
gt; Biff
gt;
gt; quot;MartinWquot; gt; wrote in message
gt; ...
gt;gt; Hi Group,
gt;gt;
gt;gt;
gt;gt;
gt;gt; I have 2 sheets. One called WORKSHEET one called REPORT.
gt;gt;
gt;gt; In the report sheet I want to copy a formula down the page so
gt;gt;
gt;gt; that the referenced cells increment by 12 instead of 1 as per
gt;gt;
gt;gt; below.
gt;gt;
gt;gt;
gt;gt;
gt;gt; C18 =IF(WORKSHEET!C10=0,quot;quot;,WORKSHEET!C12)
gt;gt;
gt;gt; C19 =IF(WORKSHEET!C22=0,quot;quot;,WORKSHEET!C24)
gt;gt;
gt;gt; C20 =IF(WORKSHEET!C34=0,quot;quot;,WORKSHEET!C36)
gt;gt;
gt;gt;
gt;gt;
gt;gt; I feel like this should be very simple but I just can't work it out,
gt;gt;
gt;gt; Any help would be much appreciated.
gt;gt;
gt;
gt;
Hi Martin,

Or this:

=IF(INDIRECT(quot;WORKSHEET!Cquot; amp; (ROW()-18)*12 10)
=0,quot;quot;,INDIRECT(quot;WORKSHEET!Cquot; amp; (ROW()-18)*12 12))

Ken JohnsonThanks Biff, Works Great!!!
Hi Ken,

I couldn't get this one to work. At first I think I confused the issue by
trying to copy and paste to an empty cell direct from your post but then
when I inputted the formula manually it only came up with #VALUE. I'm
betting that the problem is at my incompetent end but seeing that Biffs
reply works I'll go with that for now. When I've got more time I'll go
through both of them and see what I can learn.
Thanks for taking the time to post.

Cheers
Martin
Hi Martin,
Biff's formula not only works, it's also shorter!
Thanks for the feedback anyhow.
Ken JohnsonYou're welcome. Thanks for the feedback!

Biff

quot;MartinWquot; gt; wrote in message
...
gt; Thanks Biff, Works Great!!!
gt;