Need an inventory records for items which are purchased at highest price will be sold first

[masud_jahan]

Hi Experts !

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

I'll input sell quantity manually (in yellow cells of sample file) and need the sell rate to be found by formula (in blue cells of sample file).. Please help me out.

Thanks in advance.

Cross Post:

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...

www.excelforum.com

 

[masud_jahan]

Hi Experts !

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

I'll input sell quantity manually (in yellow cells of sample file) and need the sell rate to be found by formula (in blue cells of sample file).. Please help me out.

Thanks in advance.

Cross Post:

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...

www.excelforum.com

Cross Post:

https://www.reddit.com/r/excel/comments/yybcrn