close
And then start again. Example c1=1,c2=1,c3=1,c4=0 value = 3 (c1-c3) lets say
c5=1,c6=0 new value =1(c5)
D2: =MAX(1,MAX(IF(C$1:C2=quot;quot;,ROW(C$1:C2))))
which is an array formula, so commit with Ctrl-Shift-Enter, not justr enter
E2: =IF(AND(C2lt;gt;0,C3=0),SUM(INDIRECT(quot;Cquot;amp;D2amp;quot;:Cquot;amp;ROW() )),quot;quot;)
copy D2 and E2 down.
--
HTH
Bob Phillips
(remove nothere from the email address if mailing direct)
quot;tower_of_love_mquot; gt; wrote in
message ...
gt; And then start again. Example c1=1,c2=1,c3=1,c4=0 value = 3 (c1-c3) lets
say
gt; c5=1,c6=0 new value =1(c5)
全站熱搜
留言列表
