Inventory records for items which are purchased at highest price will be sold first

Hi Experts !

I need to create a workbook for inventory records where items which are purchased at highest price will be sold first.

A sample file has been attached. Please help me out.

Thanks in advance.

Cross Post:
https://www.mrexcel.com/board/thread...9/post-5978578
https://www.reddit.com/r/excel/comme...ems_which_are/

This proposed solution requires the "Buy" data be sorted by the Price/Unit column and employs helper columns.
1. The helper column headers are the dates and Units from the "Sell" data range
2. The formula used to produce the "Sub-Unit" helper columns is: =MIN(F$2-SUM(F$4:F4),$B5-SUM($E5:E5))
3. The formula that populates the "Sub-Unit" column in the "Sell" data is: =INDEX(F$5:H$8,AGGREGATE(15,6,(ROW(F$5:H$8)-ROW(F$4))/(F$1:H$1=M7)/(F$5:H$8>0),COUNTIFS(M$7:M7,M7)),MATCH(M7,F$1:H$1,0))
4. The formula that populates the "Price/Unit" column is: =INDEX(Table1[Price/Unit],AGGREGATE(15,6,(ROW(Table1[Price/Unit])-ROW(Table1[#Headers]))/(F$1:H$1=M7)/(F$5:H$8>0),COUNTIFS(M$7:M7,M7)))
Let us know if you have any questions.