and if you want opposite
then use
=COUNTIF(A1:A100,A1)
then it will be
A1 : 100 result be will B1 : 100
A2 : 100 B2 : 99
A3 : 100 B3 : 98
A4 : 100 B4 : 97
A5 : 100 B5 : 96
A6 : 100 B6 : 95
Regards
Santosh Bahuguna
On Fri, Jul 8, 2011 at 3:29 PM, santosh bahuguna
<santoshbahug...@gmail.com>wrote:
> 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
