Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Nonsequential column numbering
I have a spreadsheet that needs numbers in the far left column to track row data. Some rows have data, while others are skipped. I need to be able to number the rows sequentially _without_ numbering empty rows. Any idea how? What if I need to -insert - a row - would the solution resequence? Thanks! -- dziw ------------------------------------------------------------------------ dziw's Profile: http://www.excelforum.com/member.php...o&userid=10422 View this thread: http://www.excelforum.com/showthread...hreadid=469276 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Nonsequential column numbering
One way:
A1: 1 A2: =IF(COUNTA(B2:IV2),MAX($A$1:$A1)+1,"") Copy A2 down as far as necessary. If you inserted a row the solution would resequence. Is that what you wanted? In article , dziw wrote: I have a spreadsheet that needs numbers in the far left column to track row data. Some rows have data, while others are skipped. I need to be able to number the rows sequentially _without_ numbering empty rows. Any idea how? What if I need to -insert - a row - would the solution resequence? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change column numbering to column letters in my spreadsheet view | Excel Discussion (Misc queries) | |||
nonsequential cell references | Excel Worksheet Functions | |||
nonsequential cell references | Excel Worksheet Functions | |||
NUMBERING OF A COLUMN | New Users to Excel | |||
Column numbering | Excel Worksheet Functions |