Quote Originally Posted by PcMax View Post
It certainly would use if I were to enter a single value column.

The complete cycle involves the following calculations for each step in the column:

=SOMMA(E3:E14) 'Entry with the previous example
=SOMMA(F3:F14)*-1
=(L3/L4)
'
=SOMMA(E4:E15)
=SOMMA(F4:F15)*-1
=SOMMA(L7/L8)
'
=SOMMA(E5:E16)
=SOMMA(F5:F16)*-1
=SOMMA(L11/L12)
'

Completing the first cycle resume the calculation sequence
I'm not sure what cycle is best to use in this case
The paper uses 300.000 rows of data
I have no idea how the above flows from your first message. What is SOMMA... your local language name for the SUM function (seems unlikely since you used SUM in your first message)? What is a cycle? What is a complete cycle? What are you really trying to do? Your first message asked how the code you posted could be improved, nothing more, but your last message seems to be implying you asked something else instead (or at least it implies you think you told us more about the process than you actually did). I think you will need to provide more information before anyone will be able to help you further. Keep in mind when providing any information (and when asking future questions)... while everything about what you want to do is obvious to you, it is completely unknown to us... we only know what you tell us, so do not take for granted that we know or can deduce anything about your data, its layout or what you want to do with it.