Hi,
The formula added does not help in case Available Qty is less than last
purchase qty.
Further, Ageing can be located in more than a period.Please see red marked
result.
Formula need to be executed for line items more than 12000.
Do Not believe a formula can solve this.
Thanks a lot for
Mr.C.G.Kumar
See attached file as your require function.
Regards.
Ashish Bhalara
9624111822
P*Please do not print this email unless it is absolutely necessary. Spread
environmental üawareness.♣♣♣*
On Mon, Dec 22, 2014 at 9:44 AM, C.G.Kumar
wrote:
> Hi,
>
> I have purchase data in a spreadsheet
Hi,
I have purchase data in a spreadsheet and List of Inventory Items on
another worksheet of excel.
May someone help me with a macro or advance formula which computes Ageing
of Inventory.
Age of Inventory is calculated in Purchase Sheet but do not know how to
compute for available qty only.
Sa
