Dear ,
I want the formula for to know what qty i sold from diffrent Orders.
For Example: In Attached File you can see , there are 4 orders and total sold qty.
This sold qty i want to to from which order??
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Stock Movement by Order wise
0
Answers
0
Hi and welcome to the Forum
If your orders are sold in order (all of 1st then 2nd etc.), I put this in cell K3:
=IF($I3>=SUM($E3:F3),F3,MAX(0, $I3-SUM($E3:E3)))and copied across then down (just for 4 rows, in green). It now shows how each order was sold per order (change a value in column I to check).
Note that the dollar signs fix the column (for the SUMs) and the MAX function prevents the value going negative.
If this fixes your problem, please remember to mark this answer as Selected (following the Rules of the Forum). Thanks in advance.