have you data start in row 2, so

A2: 11,11
A3: 33,22

in C1 put in =22
in C2 put in the formula
=A2-MIN(A2,MAX($C$1-SUM($A$1:A1),0))

then drag fill it down column C to match your data.

Now, when you want to subtract additional, you can do

C1: =22+30

and the remainders will update.

You could adjust the formula in c1 to be

=Sum(D1:IV1)

then
D1: 22
E1: 30
and so forth

--
Regards,
Tom Ogilvy


"Rodrigo Ferreira" wrote:

I don't know how can I explain... I'll try:

I have a list like this:
A
11,11
33,22
11,55
66,55

And I have to subtract 22 from this list and I want a result like this:

C
0
22,33
11,55
66,55

After, I have to subtract 30 from this new list and I want a result like
this:
D
0
0
3,88
66,55

....

My list has more a lot of lines. And maybe I'll have to subtract more
values...

1- How can I calculate the column "D"?
2- Can I have a one column with this results? Without the column "C"?

Sorry for my poor english

--

Rodrigo Ferreira