Use Simple formula
=COUNTIF(A$1:A1,A1)
Please let me know if you looking for this only
Regards
Santosh Bahuguna
On Fri, Jul 8, 2011 at 8:33 AM, Rajan_Verma <rajanverma1...@gmail.com>wrote:
> *Hi
> Try this*
>
> * *
>
> *Private Sub Worksheet_Change(ByVal Target As Range)*
>
> *On Error GoTo Err:*
>
> *If Target = Range("A1") Then*
>
> *For i = 1 To Range("A1").Value*
>
> *Range("A" & i + 1).Value = i*
>
> *Next*
>
> *End If*
>
> *Err:*
>
> *End Sub*
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI
> *Sent:* Friday, July 08, 2011 5:38 PM
> *To:* excel-macros@googlegroups.com
> *Cc:* Kal xcel
> *Subject:* Re: $$Excel-Macros$$ Numbering****
>
> ** **
>
> kalyan babu.............****
>
> Please try it..also****
>
> ****
>
> =IF(A2="","",COUNTA($A$2:A2))****
>
> On Fri, Jul 8, 2011 at 4:35 PM, Kal xcel <kalx...@gmail.com> wrote:****
>
> Dear Experts,****
>
> ****
>
> I want the formula for below mention query...........****
>
> ****
>
> user will put 100 in A1, from A2 autometically numbering will start like
> this****
>
> ****
>
> A2 1****
>
> A3 2****
>
> A4 3****
>
> .****
>
> .****
>
> .****
>
> .****
>
> ****
>
> till 100****
>
> ****
>
> What will be the formula??****
>
> ****
>
> Please help****
>
> ****
>
> Thanks in advance****
>
> ****
>
> Kalyan Chatterjee****
>
> ****
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel****
>
>
>
>
> -- ****
>
> Thanks & regards,****
>
> Noorain Ansari****
>
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
> ****
>
> ** **
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel****
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
