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
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
>
>
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
>
>
>
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
>