Subtract one value from multiple others
Hi,
I would line to know if its possible to subtract a single value from multiple others until its completely utilized
I would like to have formula in column A where the numbers in column A (that also are result of a formula) decrease themselves until the number 25 is fully used
Example:
Result
column A column B --> column A column B
8 25 0 25
4 0
2 0
10 0
8 7
Last edited by misia_klu; 04-10-2024 at 07:19 AM. Reason: Missing attachement
CAn u please let us know the expected result with some more data in an excel file for our better understanding.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Just added the file
In A19 Cell
Drag the formula down...
Please Login or Register to view this content.
Last edited by :) Sixthsense :); 04-10-2024 at 07:33 AM.
Thank you for the reply, but i need the result to replace the "Start" numbers i won't be able to keep a start reference to use the solution you provided
Apologies for not being clear
That might be possible using VBA, of which I know too little to help.
A formula cannot do what you want.
Since there have been no replies in the last two days, here is how Sixthsense's formula could be modified to populate B3:B7Formula:
Please Login or Register to view this content.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Another method. In B3 copied down.
=MAX(0,SUM($A$3:$A3)-$C$3)
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks