RichardAtk
asked on
Excel first in first out formula
=MAX(MIN(SUMIF(Reserved!A: A,A2,Reser ved!C:C)-S UMIF(A1:A$ 1,A2,C$1:C 1),C2),0)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Brilliant !!! Thanks