--
From: Rajan_Verma rajanverma1...@gmail.com
To: excel-macros@googlegroups.com
Cc:
Date: Sat, 19 May 2012 16:35:27 +0300
Subject: RE: $$Excel-Macros$$ Find the number missing in other cols
Put this in F2 and Drag
=IF(COUNTIF($A$2:$C$11,E2),,Not Present)
* *
*Regards*
*Rajan
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
Dear friends,
I have a set of cols called A B C D can please help me to solve the
issue..
Note: please check the attached copy for further understanding.
Regards,
Muneer,
CC..
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles.
You need to make this clear
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Mohammed Muneer
Sent: Saturday, May 19, 2012 7:32 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Find the number missing in other cols
Dear friends,
I have a set
] On
Behalf Of dguillett1
Sent: 19 May 2012 6:42
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Find the number missing in other cols
You need to make this clear
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Mohammed Muneer mailto:mmun