Hi,
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




Reply With Quote
Bookmarks