View Single Post
  #1   Report Post  
Cutter
 
Posts: n/a
Default


Try this in B2 and copy down:

=IF(AND(MAX(B$1:B1)=0,MIN(A1:A2)0,A2=A1+1),A1+A2, "")


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=472445