Please find the attached file and let me know if is this you are looking for
Regards Santosh Bahuguna On Sat, Jul 9, 2011 at 1:42 PM, karunanithi ramaswamy <era_...@yahoo.com>wrote: > 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<http://mc/compose?to=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<http://mc/compose?to=excel-macros@googlegroups.com>[mailto: > excel-macros@googlegroups.com<http://mc/compose?to=excel-macros@googlegroups.com>] > *On Behalf Of *NOORAIN ANSARI > *Sent:* Friday, July 08, 2011 5:38 PM > *To:* > excel-macros@googlegroups.com<http://mc/compose?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<http://mc/compose?to=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<http://mc/compose?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<http://mc/compose?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<http://mc/compose?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
Countifs.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
