View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eric
 
Posts: n/a
Default How to determine following function in Excel?

I would like to set following conditions in Excel, but find it difficult on
coding.
Could anyone give me any suggestion please?

Under A Colume, there are a list of numbers
Profit
100
101
-50
-60
50
-50
-20
-10
80

Under Colume B, I would like to determine the maximum consecutive loss from
Colume A, in this case, it should return -50-60 = -110

Does anyone have any suggestion?
Thank you in advance
Eric