Thank you all....... On Mon, Jul 11, 2011 at 1:37 PM, ankur <ankurpande...@gmail.com> wrote:
> *hi kalyan > as per ur requirement....find the solution...tell me if it helps u .. > > *Have A Nice Time & Enjoy Life > > Regards: > CMA Ankur Pandey > (Someone Different) > > I'm not the best but i'm not like the rest~~ > > > > On Mon, Jul 11, 2011 at 9:49 AM, santosh bahuguna < > santoshbahug...@gmail.com> wrote: > >> >> 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 >> > > -- > > ---------------------------------------------------------------------------------- > 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
