Result without helper columns

[paradise2sr]

Hi,

I have worked on some solution which is received fine.But the problem is that it has been done with helper column.What I want is to get directly the result without using helper column.

My final Results are at AM:AS
Helper columns are-AD:AJ
Main data is U column which is to be adjusted at columns V:AB in ascending order.I have mentioned 1,2,3,4,5,6,7 just for understanding purposes.

I hope this would help to comprehand.

[josephteh]

Try, =MIN(MAX(0,SUM(V123:$AB123)-$U$123),V123), copy across.

[paradise2sr]

Seems to have got the same result.Can you explain so that I can use it for solving issues in future.

[josephteh]

3 steps:
(1) Cumulative SUM in range V123:AB123 (sum backwards) less value in cell U123
(2) Ignore negative values in step (1)
(3) Take the minimum values in step (2) and original values in range V123:AB123

[paradise2sr]

Thanx for the explanation.