Home |
Search |
Today's Posts |
#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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I arrange numbers in asending order in Excel? | Excel Discussion (Misc queries) | |||
how write excel formula numbers in column => &=< between 20-40 | New Users to Excel | |||
How do I get auto fill to do decending numbers in a column? | Excel Discussion (Misc queries) | |||
How can I reverse the order of a column of numbers . . . | Excel Discussion (Misc queries) | |||
How can I reverse the order of a column of numbers . . . | Excel Discussion (Misc queries) |