ime.
BS
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Maries
Sent: Sun, 06-May-2012 12:53 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Formula required for finding Consumption value
for giving cons. Qty.
Revised...
O
t;> The closing value of stock will be calculated on the Balance Quantity (@
>> of last purchase rate)
>>
>> ** **
>>
>> Thanks & Regards,
>>
>> BS
>>
>> ** **
>>
>> ** **
>>
>> ** **
>>
>> ** **
>
From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Maries
> *Sent:* Sun, 06-May-2012 11:46 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Formula required for finding Consumption
> value for giving con
: Re: $$Excel-Macros$$ Formula required for finding Consumption value
for giving cons. Qty.
Can you explain more about FIFO calculation.
On Fri, May 4, 2012 at 8:19 PM, B Sharma wrote:
Dear Friends and excel experts,,
I have a sheet in which there are columns like "Qty"
*Can you explain more about FIFO calculation.*
On Fri, May 4, 2012 at 8:19 PM, B Sharma wrote:
> Dear Friends and excel experts,,
>
> I have a sheet in which there are columns like "Qty""Rate" of purchase
> of items,
> In Another sheet I need a formula for auto calculation of consumption
Dear Friends and excel experts,,
I have a sheet in which there are columns like "Qty""Rate" of purchase
of items,
In Another sheet I need a formula for auto calculation of consumption value
of goods for the given quantity in FIFO method (First In First Out)
I have tried all my known tricks,
