Thanks a lot Rajan and Ashish I really appreciate your knowledge
and great help
On 10/2/12, ashish koul wrote:
> try the attachment change c38 as per ur last row
>
>
>
> On Tue, Oct 2, 2012 at 10:56 AM, Rajan_Verma
> wrote:
>
>>
>> Try this
>>
>> =IF(C1="",IF(SUMPRODUCT(N($B$1:$B$16=B1)*N
Try this
=IF(C1="",IF(SUMPRODUCT(N($B$1:$B$16=B1)*N($C$1:$C$16<>"")*$F$1:$F$16)=F1,"Y
es","No"),"")
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ankur kochar
Sent: 02 October 201
