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