RE: $$Excel-Macros$$ count formula problem...

2012-04-09 Thread Mohammed Muneer
Thank u Noor... 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 Problem, and Need Advice will not get quick attention or may n

RE: $$Excel-Macros$$ count formula problem...

2012-04-09 Thread Mohammed Muneer
Thanks Group.. 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 Problem, and Need Advice will not get quick attention or ma

Re: $$Excel-Macros$$ count formula problem...

2012-04-09 Thread NOORAIN ANSARI
Dear Muneer, Please use below formula in B2 and copy down =SUMPRODUCT(--($A$2:$A$1393=A2)) On Sat, Apr 7, 2012 at 12:32 PM, Mohammed Muneer wrote: > Please find the attachment. > > ** ** > > ** ** > > Regards, > > Muneer, > > CC... > > ** ** > > ** ** > > -- > FORUM RULES (98

RE: $$Excel-Macros$$ count formula problem...

2012-04-07 Thread Rajan_Verma
? From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ojemeni Uzoma Sent: Apr/Sat/2012 03:13 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ count formula problem... A Ojemeni Uzoma | Call 08060700717 _ From: Aamir

Re: $$Excel-Macros$$ count formula problem...

2012-04-07 Thread Ojemeni Uzoma
A Ojemeni Uzoma | Call 08060700717 -Original Message- From: Aamir Shahzad Sender: excel-macros@googlegroups.com Date: Sat, 7 Apr 2012 12:18:21 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ count formula problem... but this formula is counting 2 of unique

RE: $$Excel-Macros$$ count formula problem...

2012-04-07 Thread Rajan_Verma
Do you want this : =IF(COUNTIF($A$2:A2,A2)=1,COUNTIF($A$2:A2,A2),"") Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mohammed Muneer Sent: Apr/Sat/2012 12:33 To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ cou

Re: $$Excel-Macros$$ count formula problem...

2012-04-07 Thread Aamir Shahzad
but this formula is counting 2 of unique numbers also. Aamir Shahzad On Sat, Apr 7, 2012 at 12:10 PM, The Viper wrote: > =COUNTIF($A$2:$A$1393,A2) > or > =COUNTIF(A:A,A2) in a2 and copy down > > > > > On Sat, Apr 7, 2012 at 12:32 PM, Mohammed Muneer wrote: > >> Please find the attachment. >> >

Re: $$Excel-Macros$$ count formula problem...

2012-04-07 Thread The Viper
=COUNTIF($A$2:$A$1393,A2) or =COUNTIF(A:A,A2) in a2 and copy down On Sat, Apr 7, 2012 at 12:32 PM, Mohammed Muneer wrote: > Please find the attachment. > > ** ** > > ** ** > > Regards, > > Muneer, > > CC... > > ** ** > > ** ** > > -- > FORUM RULES (986+ members already BANNED

Re: $$Excel-Macros$$ count formula problem...

2012-04-06 Thread The Viper
attachment?? On Sat, Apr 7, 2012 at 12:08 PM, Mohammed Muneer wrote: > Dear friends can u please check the attached for the above subject. > > ** ** > > ** ** > > Regards, > > Muneer, > > CC... > > ** ** > > ** ** > > -- > FORUM RULES (986+ members already BANNED for violation)