Re: [RT] excell help

["kevin miles" <erowis@xxxxxxxx>]

Got it folks.  Thanks to Calaxcorp.  

 
Here's what works:
 
=I<FONT 
face="Book Antiqua">F(W6=0,0,W6+AS5)
 
Then the max value function applied to that 
column.
 
Thanks all,
 
kevin
<BLOCKQUOTE 
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
  ----- Original Message ----- 
  <DIV 
  style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: 
  CP4w@xxxxxxx 
  To: <A title=realtraders@xxxxxxxxxxxxxxx 
  href="mailto:realtraders@xxxxxxxxxxxxxxx";>realtraders@xxxxxxxxxxxxxxx 
  
  Sent: Sunday, July 08, 2001 7:18 PM
  Subject: Re: [RT] excell help
  Maybe this'll help--I'm 
  just guessing In a separate column use the if function (if b2 = 1, d2 = 
  @sum(b1 + b2), d2 = 0) Copy the above down the column. The basic 
  idea is to cummulate successive 1's, a non-1 starts the count over again. 
  You can then get the max number in col d. I haven't tried this, so 
  it's a guess at what might work. To unsubscribe from this 
  group, send an email 
  to:realtraders-unsubscribe@xxxxxxxxxxxxxxxYour 
  use of Yahoo! Groups is subject to the <A 
  href="http://docs.yahoo.com/info/terms/";>Yahoo! Terms of Service. 




To unsubscribe from this group, send an email to:
realtraders-unsubscribe@xxxxxxxxxxxxxxx





Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.