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
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
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
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
a2= a1+1
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
A21
A32
A43
.
.
.
.
till 100
What will be
Dear Experts,
I want the formula for below mention query...
user will put 100 in A1, from A2 autometically numbering will start like
this
A21
A32
A43
.
.
.
.
till 100
What will be the formula??
Please help
Thanks in advance
Kalyan Chatterjee
--
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
Dear Ashish,
I want the numbering will start frm 1 and it will end at the number given by
user, like if user put 100 so numbering 1,2,3,4,5,6,7100, if
user put 200 numbering will start from 1,2,3,4,5,6,7,8,9,10200.
I think you got what I am saying.
Thanks in advance
try this
On Fri, Jul 8, 2011 at 5:40 PM, Kal xcel kalx...@gmail.com wrote:
Dear Ashish,
I want the numbering will start frm 1 and it will end at the number given
by user, like if user put 100 so numbering 1,2,3,4,5,6,7100, if
user put 200 numbering will start from
Dear Kalyan,
Please try it
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim i, j, k As Long
i = Sheet1.Range(A1).Value
Sheet1.Range(A2:A1000).Clear
For j = 2 To i + 1
Sheet1.Cells(j, 1).Value = k + 1
k = k + 1
Next
End Sub
--
Thanks regards,
Noorain Ansari
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
*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
: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
A2, copy down as many needed
=IF(ROWS(A$2:A2)=A$1,ROWS(A$2:A2),)
Or, If you are inserting rows between A2 the last rows this will not work
as expected, so use this one;
=IF(COUNT(A$1:A1)=A$1,COUNT(A$1:A1),)
copy down as many needed
HTH
Haseeb
--
14 matches
Mail list logo