Solved

Excel first in first out formula

Posted on 2014-11-03
3
386 Views
Last Modified: 2014-11-03
Hi

I am looking for some help on the attached excel first in first out formula.
fifoexample.xlsx
0
Comment
Question by:RichardAtk
  • 2
3 Comments
 
LVL 24

Expert Comment

by:Phillip Burton
ID: 40419395
=MAX(MIN(SUMIF(Reserved!A:A,A2,Reserved!C:C)-SUMIF(A1:A$1,A2,C$1:C1),C2),0)
0
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 500 total points
ID: 40419397
Here it is attached.
fifoexampleanswer.xlsx
0
 

Author Closing Comment

by:RichardAtk
ID: 40419404
Brilliant !!!  Thanks
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Viewers will learn a basic data manipulation technique of unpivoting data in Power Query for Excel 2013 and the importance of using good data. Start with data in a poor structure: Create a table on your data: Unpivot columns: Rename columns: …
Video by: Zack
Viewers will learn the basics of using Excel Tables, the benefits found with them, and some pitfalls.

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now