Re: $$Excel-Macros$$ How to find consodated sale data of previous 3 months

2010-10-09 Thread Kal xcel
Hi Sumit, I had called you several times for my previous query regarding "outstanding status", but it saying number invalid. I need to speak to you. In this case, I can't use pivot table in this scenario. Because lot of other issues attached with this. I have to use formula here. Thanks Kalyan

Re: $$Excel-Macros$$ How to find consodated sale data of previous 3 months

2010-10-08 Thread SUMIT VYAS
Dear one colum set structure :- month = jan-2008 jan-2009 jan-2010 then use use pivot table On Sat, Oct 9, 2010 at 10:34 AM, Kal xcel wrote: > Hi Worawat, > > Thanks for your advice. But I can't use pivot table in this scenario. > Because lot of other issues attached with this. > > Thanks > >

Re: $$Excel-Macros$$ How to find consodated sale data of previous 3 months

2010-10-08 Thread Kal xcel
Hi Worawat, Thanks for your advice. But I can't use pivot table in this scenario. Because lot of other issues attached with this. Thanks Kalyan On Sat, Oct 9, 2010 at 3:43 AM, worawat kh wrote: > Hi Kalyan > > You can use pivot table to solve this , > better than use many excel function > > >

Re: $$Excel-Macros$$ How to find consodated sale data of previous 3 months

2010-10-08 Thread worawat kh
Hi Kalyan You can use pivot table to solve this , better than use many excel function Worawat 2010/10/8, Kal xcel : > Dear Experts, > > I want to extract last 3 months consolidated sale data based on current > month. > > I have attached the file with my query. > > Thanks in advance > > Kalyan >