Thank you very much to one and all.. for giving response... it worked ...
it saves me a lot of time ... for a mammoth data of having 65000 records...
Raghu Nandan R
On Mon, Jan 9, 2012 at 9:07 PM, Rajan_Verma wrote:
> Put this in C2 and fill down.
>
> ** **
>
> =IF(A2=A3,"",COUNTIF($A$2:$A$17
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 having same dat
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 hav
