Solved

Excel first in first out formula

Posted on 2014-11-03
3
348 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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Suggested Solutions

Moving applications to the cloud or switching services to cloud-based ones, is a stressful job.  Here's how you can make it easier.
What is Backup? Backup software creates one or more copies of the data on your digital devices in case your original data is lost or damaged. Different backup solutions protect different kinds of data and different combinations of devices. For e…
Video by: Zack
Viewers will learn about various customizable options in Excel 2013.
Viewers will learn how to share Excel data with others from desktop Excel, as well as Excel Online via OneDrive, and embed an Excel file on a website.

743 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

9 Experts available now in Live!

Get 1:1 Help Now