If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Auto generate numbers in decending order in a column
I just want to know how I can set up a column to auto generate numbers in
decsending order? |
#2
|
|||
|
|||
Auto generate numbers in decending order in a column
You could add a formula: =if(isblank(b2),"",a2+1) would be it for row 3 if
you, for instance, type a date in column B. But you'd need a macro to make it happen automatically. ************ Anne Troy www.OfficeArticles.com "JsJ" wrote in message ... I just want to know how I can set up a column to auto generate numbers in decsending order? |
#3
|
|||
|
|||
Auto generate numbers in decending order in a column
In article ,
says... I just want to know how I can set up a column to auto generate numbers in decsending order? Depending on what you mean by auto generate... Put the largest desired number (say 100) in a cell and the next largest number (99 in my case) in the cell below it. Then, select both cells, move the mouse to the bottom right of the selection (it will become a black cross) and click and drag as far down as needed. I am not sure how Anne's solution works here since it generates ascending numbers based on the content of the adjacent column. Maybe she knows something I don't. ;-) -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Return Count for LAST NonBlank Cell in each Row | Sam via OfficeKB.com | Worksheet Functions | 12 | April 17th, 2005 10:36 PM |
Average of numbers in column between to other numbers | Ditandhischeese | General Discussion | 2 | March 31st, 2005 03:35 AM |
How can I reverse the order of a column of numbers . . . | Wyoming Buckeye | General Discussion | 0 | January 14th, 2005 07:31 PM |
Wrong sort order of report's details section | dsjohn_242 | Setting Up & Running Reports | 6 | July 12th, 2004 10:21 PM |
auto assign numbers to purchase order | matt | Worksheet Functions | 1 | December 19th, 2003 05:02 PM |