The attached has a Sales column that relies on 2 helper columns that I'd like to eliminate but have been unsuccessful building the requisite formula.
Thanks in advance for your assistance would be appreciated.
The catch is that the Lambda function is intended to deal with multiple products, bought in over time at varying cost price, and meeting a fluctuating demand. The objective is to identify the purchase batch/es for any given sale to calculated the cost of sales on an order by order basis.
It works, but it represents a very large sledgehammer to crack a rather modest nut!