Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sequential numbers
I simply want to sequentially number rows in a column. However, some of the
rows do not contain any data so do not need to be numbered. So there is in fact a blank. It´s also possible that i´d want to add another row, and auto update the number sequence. You cannot drag the auto numbering facility across cells that you want to remain empty of course, because they will be numbered. |
#2
|
|||
|
|||
With your data in column A,:
Formula in B1 :1 In B2: =IF(A2="",B1,B1+1) Fill down. Format B2: FormatConditional Formatting Cell Value is, Equal to, B1 (remove the $signs if you clicked B1) Choose a white font, so the number doesn't show Use the format painter or Copy, Paste Special Format to format the rest of the cells. -- Kind regards, Niek Otten Microsoft MVP - Excel "AndrewRichardWood" wrote in message ... I simply want to sequentially number rows in a column. However, some of the rows do not contain any data so do not need to be numbered. So there is in fact a blank. It´s also possible that i´d want to add another row, and auto update the number sequence. You cannot drag the auto numbering facility across cells that you want to remain empty of course, because they will be numbered. |
#3
|
|||
|
|||
Here's a way using two helper columns.
1) in the first helper column, sequentially number every row. 2) sort the sheet so all the blank rows are at (say) the bottom 3) in the second helper column, sequentially number every row, apart from the blank ones at the end 4) resort the sheet by the numbers in the first helper column 5) delete the first helper column, which leaves only the non-blank rows sequentially numbered -- Andy Wiggins FCCA www.BygSoftware.com Excel, Access and VBA Consultancy - "AndrewRichardWood" wrote in message ... I simply want to sequentially number rows in a column. However, some of the rows do not contain any data so do not need to be numbered. So there is in fact a blank. It´s also possible that i´d want to add another row, and auto update the number sequence. You cannot drag the auto numbering facility across cells that you want to remain empty of course, because they will be numbered. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Controlling Sequential Numbers | Excel Discussion (Misc queries) | |||
How do I assign sequential numbers in an Excel 2003 PO template? | Excel Worksheet Functions | |||
How can i print sequential page numbers 1 to 10, if i have one wo. | Excel Discussion (Misc queries) | |||
list of sequential numbers | Excel Discussion (Misc queries) | |||
How do I take two columns of sequential numbers and insert spaces | Excel Discussion (Misc queries) |