Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for Numbers in Running Sequence
In my excel sheet, at A5 is the starting numerial no 1 and end at A177. Is
there a formula that the numbers will be in running sequence, no doubt I delete/ insert a row or select an autofilter in H4, the numbers will still be in running sequence? Thanks in advance! Sha |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for Numbers in Running Sequence
Hi
In cell A5 enter =ROW(A1) Copy down as far as far as A177 Deletions will be fine, but if you insert a row, then in the blank cell in column A of the new row, copy down the formula from the cell above. -- Regards Roger Govier "sha" wrote in message ... In my excel sheet, at A5 is the starting numerial no 1 and end at A177. Is there a formula that the numbers will be in running sequence, no doubt I delete/ insert a row or select an autofilter in H4, the numbers will still be in running sequence? Thanks in advance! Sha |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sequence of numbers | Excel Worksheet Functions | |||
average numbers in sequence | Excel Worksheet Functions | |||
sequence numbers | Excel Discussion (Misc queries) | |||
sequence numbers | Excel Discussion (Misc queries) | |||
how do I sequence numbers | Excel Discussion (Misc queries) |