: excel-macros@googlegroups.com
Subject: Re: FW: $$Excel-Macros$$ Find the number missing in other cols
You also can use:
=IF(SUMPRODUCT(--($A$2:$C$11=E2)*($E$2:$E$11))>1,"","Not Present")
Regards,
Aamir Shahzad
On Sun, May 20, 2012 at 8:46 AM, Mohammed Muneer
el-macros@googlegroups.com] *On Behalf Of *Aamir Shahzad
> *Sent:* 20 May 2012 1:41
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: FW: $$Excel-Macros$$ Find the number missing in other cols*
> ***
>
> ** **
>
> You also can use:
>
> ** **
>
> =IF(SUMP
You also can use:
=IF(SUMPRODUCT(--($A$2:$C$11=E2)*($E$2:$E$11))>1,"","Not Present")
Regards,
Aamir Shahzad
On Sun, May 20, 2012 at 8:46 AM, Mohammed Muneer wrote:
> HI, Rajan its working that’s what I exactly want to do.
>
>
>
> Thanx Buddy….
>
>
>
>
>
>
>
> Regards,
>
> Muneer,
>
> CC….
>
HI, Rajan its working that's what I exactly want to do.
Thanx Buddy
Regards,
Muneer,
CC
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Probl
