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 mmun...@ccc.com.qa wrote:
HI, Rajan its working that’s what I exactly want to do.
Thanx Buddy….
Regards,
Muneer,
CC….
--
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(SUMPRODUCT(--($A$2:$C$11=E2)*($E$2:$E$11))1,,Not Present)
** **
Regards
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(SUMPRODUCT(--($A$2:$C$11=E2)*($E$2:$E$11))1,,Not Present)
Regards,
Aamir Shahzad
On Sun, May 20, 2012 at 8:46