RE: FW: $$Excel-Macros$$ Find the number missing in other cols

2012-05-20 Thread Rajan_Verma
: 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

Re: FW: $$Excel-Macros$$ Find the number missing in other cols

2012-05-20 Thread Aamir Shahzad
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

Re: FW: $$Excel-Macros$$ Find the number missing in other cols

2012-05-20 Thread Aamir Shahzad
-- > To post to this group, send email to excel-macros@googlegroups.com > > > ------ Forwarded message -- > From: "Rajan_Verma" > To: > Cc: > Date: Sat, 19 May 2012 16:35:27

FW: $$Excel-Macros$$ Find the number missing in other cols

2012-05-19 Thread Mohammed Muneer
os@googlegroups.com [mailto:excel-macros@googlegroups.com] 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 dguill

Re: $$Excel-Macros$$ Find the number missing in other cols

2012-05-19 Thread dguillett1
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

$$Excel-Macros$$ Find the number missing in other cols

2012-05-19 Thread Mohammed Muneer
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.