Re: $$Excel-Macros$$ Re: Help needed

Dear Kumar, Deciding min Max level based on 3 month data is bit unscientific,you need to have at least 6 months data. Based on data provided by you, I have answered your queries. As mentioned by you GEOFORCE is external warehouse. It is not clear if the stock at other location is replenished from

$$Excel-Macros$$ Re: Help needed

Hi, Any one looked at it? On Wednesday, April 15, 2015 at 3:13:43 PM UTC+1, kumar wrote: > > Hi, > > Just want to solve the questions with analysis. > please find the enclosed attachment and answer the question. I also trying > to solve. But needed Gurus help. > > Thanks > -- Are you =EXP(E:RT

$$Excel-Macros$$ Help needed

Hi, Just want to solve the questions with analysis. please find the enclosed attachment and answer the question. I also trying to solve. But needed Gurus help. Thanks -- 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

Re: $$Excel-Macros$$ Re: Populating rows using a range of data

Hi , Please check the attached file. Regards Gaurav Devrani On Wed, Apr 15, 2015 at 3:54 PM, Umar Abeer wrote: > Hi Mandeep, > > Many thanks. It serves the purpose but is there any way we can use > index/match or any range formula to achieve the same? > > BR > Aby > > On Wed, Apr 15, 2015 at

Re: $$Excel-Macros$$ Re: Populating rows using a range of data

Hi Mandeep, Many thanks. It serves the purpose but is there any way we can use index/match or any range formula to achieve the same? BR Aby On Wed, Apr 15, 2015 at 1:12 PM, Mandeep Baluja wrote: > check this out. the value which is blank does not go into the bucket you > have set. > > Regards,

$$Excel-Macros$$ Re: Populating rows using a range of data

check this out. the value which is blank does not go into the bucket you have set. Regards, Mandeep Baluja On Wednesday, April 15, 2015 at 2:21:15 PM UTC+5:30, dinoabeer wrote: > > Dear Experts, > > I have been trying to figure out a way to populate the row D9 to AM9 based > on the table

$$Excel-Macros$$ Re: Populating rows using a range of data

Dear Experts, I have been trying to figure out a way to populate the row D9 to AM9 based on the table provided D14 to J18. I have tried index/match but to no avail. Any help in appreciated. Best Regards Aby -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,

Re: $$Excel-Macros$$ Re: Working with Merged cells : Sumproduct/Countifs

Hello, Thanks much :-) On Tue, Apr 14, 2015 at 8:34 PM, Vaibhav Joshi wrote: > Check this... > > Add two helper column & see formula in Green, i have tested for both of > sample data given by you & its working.. > > > Cheers!! > > On Tue, Apr 14, 2015 at 5:39 PM, Chandra Shekar < > chandrasheka