ot;",COUNTIF($A$2:$A$17,A2))
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *raghunandan rallapalli
> *Sent:* Jan/Mon/2012 01:59
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ count a
Put this in C2 and fill down.
=IF(A2=A3,"",COUNTIF($A$2:$A$17,A2))
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of raghunandan rallapalli
Sent: Jan/Mon/2012 01:59
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ count a cell h
Dear Raghunandan,
Try it..
=IF(SUMPRODUCT(--($A$2:$A$17=A2))=SUMPRODUCT(--($A$2:A2=A2)),SUMPRODUCT(--($A$2:$A$17=A2)),"")
or
=IF(COUNTIF($A$2:$A$17,A2)=COUNTIF($A$2:A2,A2),COUNTIF($A$2:$A$17,A2),"")
See attached sheet...
--
Thanks & regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com
please find attached solution
Date: Mon, 9 Jan 2012 13:58:44 +0530
Subject: $$Excel-Macros$$ count a cell having same data it appeared in number
of times
From: raghunandan.rallapa...@gmail.com
To: excel-macros@googlegroups.com
Sir, kindly find the attachment and help me to get count a cell
Sir,
kindly find the attachment and help me to get count a cell having same data
it appeared in number of times..i need a formula for this..
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help
