?
Solved

Excel first in first out formula

Posted on 2014-11-03
3
Medium Priority
?
863 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 2000 total points
ID: 40419397
Here it is attached.
fifoexampleanswer.xlsx
0
 

Author Closing Comment

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

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

: Microsoft Office Collaborate for free and online versions of Microsoft  Word, Excel, Powerpoint, OneNote, Onedrive , Email, Calendar etc. In short we can say that Microsoft office is a suite of servers, applications and services developed by  Micr…
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
Viewers will learn a basic relationship technique in Power Pivot for Excel 2013.
Video by: Zack
Viewers will learn the basics of using Excel Tables, the benefits found with them, and some pitfalls.

770 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