Re: $$Excel-Macros$$ find attach sheet.. kindly help me. thanks

2012-01-24 Thread yasir_shahjee
Thanks but i need on sheet no in pivot table. On Tue, Jan 24, 2012 at 12:01 PM, PrIyAnKa wrote: > Dear Yasir > > Simply u can do it with Pivot Tabe option , > > Kindly find the attached file for the same > > > On Tue, Jan 24, 2012 at 10:28 AM, yasir_shahjee > wrote: > >> Respected Members. >> >

Re: $$Excel-Macros$$ find attach sheet.. kindly help me. thanks

2012-01-24 Thread Shaik Waheed
Hi, can u tell how u r getting the SR# On Tue, Jan 24, 2012 at 1:58 PM, yasir_shahjee wrote: > Thanks but i need on sheet no in pivot table. > > > On Tue, Jan 24, 2012 at 12:01 PM, PrIyAnKa wrote: > >> Dear Yasir >> >> Simply u can do it with Pivot Tabe option , >> >> Kindly find the attached fi

Re: $$Excel-Macros$$ find attach sheet.. kindly help me. thanks

2012-01-24 Thread yasir_shahjee
Still waiting On Tue, Jan 24, 2012 at 4:06 PM, Shaik Waheed wrote: > Hi, can u tell how u r getting the SR# > > > On Tue, Jan 24, 2012 at 1:58 PM, yasir_shahjee wrote: > >> Thanks but i need on sheet no in pivot table. >> >> >> On Tue, Jan 24, 2012 at 12:01 PM, PrIyAnKa wrote: >> >>> Dear Yasir

Re: $$Excel-Macros$$ find attach sheet.. kindly help me. thanks

2012-01-24 Thread Sam Mathai Chacko
Put in C3 and drag down =SUMPRODUCT(IF(A3&B3=A2&B2,C2,IF(B3=B2,C2+1,1))) Regards, Sam Mathai Chacko On Tue, Jan 24, 2012 at 5:03 PM, yasir_shahjee wrote: > Still waiting > > > On Tue, Jan 24, 2012 at 4:06 PM, Shaik Waheed wrote: > >> Hi, can u tell how u r getting the SR# >> >> >> On Tue, Jan 2

Re: $$Excel-Macros$$ find attach sheet.. kindly help me. thanks

2012-01-24 Thread yasir_shahjee
Thank You So much for helping. On Tue, Jan 24, 2012 at 6:55 PM, Sam Mathai Chacko wrote: > Put in C3 and drag down > > =SUMPRODUCT(IF(A3&B3=A2&B2,C2,IF(B3=B2,C2+1,1))) > > Regards, > Sam Mathai Chacko > > > On Tue, Jan 24, 2012 at 5:03 PM, yasir_shahjee wrote: > >> Still waiting >> >> >> On Tue,