Thanks to all for the great ideas & suggestions.
Regards
Karan Singh
On Tue, Sep 25, 2012 at 7:12 PM, Rajan_Verma wrote:
> *=Countif() *
>
> * *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@go
=Countif()
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Karan Singh
Sent: 25 September 2012 11:29
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Serial Number with Duplicate Values
Dear Karan,
Pl refer attachment..
Rgds//Vabs
On Tuesday, September 25, 2012 11:45:37 AM UTC+5:30, neeraj chauhan wrote:
>
> Try this
>
>
>
>
>
> 10453
>
> =COUNTIF($A$1:A1,A1)
>
> 10453
>
> =COUNTIF($A$1:A2,A2)
>
> 10453
>
> =COUNTIF($A$1:A3,A3)
>
> 25623
>
> =COUNTIF($A
Try this
10453
=COUNTIF($A$1:A1,A1)
10453
=COUNTIF($A$1:A2,A2)
10453
=COUNTIF($A$1:A3,A3)
25623
=COUNTIF($A$1:A4,A4)
5882
=COUNTIF($A$1:A5,A5)
5856
=COUNTIF($A$1:A6,A6)
2556
=COUNTIF($A$1:A7,A7)
2556
=COUNTIF($A$1:A8,A8)
From: excel-macros@googlegroups.com [
