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 mmun...@ccc.com.qa wrote: Please find the attachment. ** ** ** ** Regards, Muneer, CC... ** ** ** ** -- FORUM RULES

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

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

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

2012-04-07 Thread Mohammed Muneer
Dear friends can u please check the attached for the above subject. 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,

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

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

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 mmun...@ccc.com.qa wrote: Please find the attachment. ** ** ** ** Regards, Muneer, CC... ** ** ** ** -- FORUM RULES (986+ members already

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 viper@gmail.com 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 mmun...@ccc.com.qawrote:

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$$ count formula

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

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

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