FIFO calculation means calculation on the basis of First In First Out.
In a year we purchase goods on different rates,
For Example
In April I purchased 10 Pcs @ Rs. 5.00
In May I purchased 5 Pcs @ Rs. 6.00
In June I purchased 8 Pcs @ Rs. 5.50
So when I will put the consumption for t
*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
Can u send a sample file.
Regards
Kumar
On Mon, Apr 30, 2012 at 3:32 AM, Alan wrote:
> I have two sets of Excel worksheets I am trying to compare. The cells
> contained multiple lines of text. Some identical-looking lines do not
> compare with string1 = string2 syntax. It appears the compari
2012/5/4 Deba Ranjan
> *Congrats Rajan Shahab,
>
>And Thanks every member of Excel forum who have devoted their times in
> analytical for solving problem and vice versa.
> *
>
>
> Thanks & Regards,*
> *
>
> *Deba Ranjan P***
>
>
>
> On Fri, May 4, 2012 at 2:45 PM, Ankit Agrawal
> wrote:
>
>>
Dear Experts,
Please help me in the following issues :-
1.I want to know how to get auto serial numbers in filtered data (in
stead of 2,5,7, etc...)
2.Similarly in case of data validation if my data increases it should
reflect in drop down automatically.
Thanks & Regards.
Nalin
Hi,
Check the attachment.
Regards,
MARIES.
On Fri, May 4, 2012 at 12:27 PM, Tony Wu wrote:
> Hello,
>
> I have a file for the forecast demand, some parts have substitution, what
> I need is if the part has substitution, the original demand will be added
> to the new part and original dema
Try this too,
=QUOTIENT(A1,1000)*1000
On Sat, May 5, 2012 at 5:47 AM, Maries wrote:
> *Asa, Good Information*
>
>
> On Fri, May 4, 2012 at 6:44 PM, Asa Rossoff wrote:
>
>> Hi Shekhar,
>>
>> ** **
>>
>> Either of these:
>>
>> =ROUNDDOWN(A1,-3)
>>
>> =MROUND(A1-500,1000)
*Asa, Good Information*
On Fri, May 4, 2012 at 6:44 PM, Asa Rossoff wrote:
> Hi Shekhar,
>
> ** **
>
> Either of these:
>
> =ROUNDDOWN(A1,-3)
>
> =MROUND(A1-500,1000)
>
> ** **
>
> If you wanted to round to the nearest multiple of 1000, instead of
> rounding down, you cou
hi,
thankyou. the tracker looks good. but it allows the user to have the same
day off for two consecutive weeks. and also allows the user to choose
multiple days off in the same week.
please help in putting these two conditions.
1. the user should not be allowed to have the same day off for 3
Hi,
Check below link,
http://www.angelfire.com/biz7/julian_s/julian/julians_macros.htm
Regards,
MARIES.
On Sat, May 5, 2012 at 4:41 AM, karthik N wrote:
> Hi Friends,
>
>
> How learn the macro's in step by step,kindly provide the any macro
> tutorial website
>
>
> Pls Help
>
> Regards
> kar
Hi Friends,
How learn the macro's in step by step,kindly provide the any macro tutorial
website
Pls Help
Regards
karthik.N
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Pro
Hi,
Find the attachment.
Regards,
MARIES.
On Fri, May 4, 2012 at 11:03 PM, Vijayendra Rao wrote:
> Dear Deba Ranjan,
>
> Thanks for efforts, I knew this formula and it was not solved my problem.
>
> I need the below details if any one worked 4th October 2011 to 4th May 2012
> - Total days
contect to NOORAIN
@
From: vijayajith VA
To: excel-macros@googlegroups.com
Sent: Saturday, May 5, 2012 11:31 AM
Subject: Re: $$Excel-Macros$$ Please suggest as i want to learn MS-Access
(Noida)
HI prince
Try this.
MVP'S Web Links
Al Campagna http
Sent on my BlackBerry® from Vodafone
-Original Message-
From: joseph.cam...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Sat, 5 May 2012 04:32:26
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Charts
Hi,
I create a lot of stacked charts and I spend a lo
14 matches
Mail list logo
