Mr Santhosh,
your formula put 1 in A2,1 IN A3,2 IN A4,AGAIN 1 IN A5,3 IN A6.
i.e., REQUIRED NUMBERING FILLED IN EVEN CELLS, AND ODD CELLS HAVE 1
AM I RIGHT?
R.KARUNANITHI
--- On Sat, 7/9/11, santosh bahuguna <santoshbahug...@gmail.com> wrote:
From: santosh bahuguna <santoshbahug...@gmail.com>
Subject: Re: $$Excel-Macros$$ Numbering
To: excel-macros@googlegroups.com
Date: Saturday, July 9, 2011, 3:59 AM
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/
--
----------------------------------------------------------------------------------
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
--
----------------------------------------------------------------------------------
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
