Holding period

Use Search http://www.excelforum.com/search.php .
With keyword "LIFO".
If that answers your question let us know.
If not, post a sample workbook (attachment) with sample input data and manually assesed output.