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

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

Hi Kalyan You can use pivot table to solve this , better than use many excel function Worawat 2010/10/8, Kal xcel kalx...@gmail.com: 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

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

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 worawat...@gmail.com wrote: Hi Kalyan You can use pivot table to solve this , better than use many

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

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 kalx...@gmail.com 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.