hi value in local currency is rate or total amount?
On Mon, Nov 11, 2013 at 10:05 AM, C.G.Kumar <kumar.bemlmum...@gmail.com>wrote: > Hi, > > Please advise how to use get all data matching specific condition. > (Vlookup captures only first in data range) > > Sample file attached. > > ---------- Forwarded message ---------- > From: C.G.Kumar <kumar.bemlmum...@gmail.com> > Date: Sat, Nov 9, 2013 at 3:38 PM > Subject: $$Excel-Macros$$ Formula/ macro to Determine FIFO Stock > To: "excel-macros@googlegroups.com" <excel-macros@googlegroups.com> > Cc: Aindril De <aind...@gmail.com>, Dilip Pandey <dilipan...@gmail.com>, > Anish Kumar <anish....@gmail.com> > > > Hi, > > > I am confronting a situation where I need to determine Stock Vale of items > in Inventory based on recent prices of purchase (FIFO Explained briefly at > bottom of email who intend to know). > > Have Purchase data for the year and count of Inventory. I need to > calculate FIFO value of Inventory. > > Did manually for few line item but looking at large list , expect some > expert if these data can be plotted using some formula or macro. > > Attached Excel File for your review and valuable suggestion. > > Thanks for reading and special thanks in advance for those who understand > and can help me. > > > ( For those who do not know FIFO , let me explain briefly as what it is. > In Inventory Sheet, i need to see how much qty left, and then look in > purchase data as how much qty purchased most recently, if the qty purchased > is more than qty left, this purchase rate will be considered else we move > to purchase made before most recent purchase and then see if the qty left > is less than or equal to these purchase and the process continues.) > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/groups/opt_out. > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/groups/opt_out. > -- Thanks & Regards Vinay Saraf | Asst. Audit Manager Lodha & Co. Chartered Accountants C-1, Upasana Building, 1 – Hailey Road, New Delhi - 110001 ________________________________________________ Please consider the environment before printing this e-mail -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
