Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sequential Numbering.
I have a column of numbers in
assorted sequential but non contiguous blocks from 4 to 30. I seek a formula to renumber them 1 and onwards, until a lower number is found, whereupon they would begin again at 1. Can anyone assist please? eg: Col A 2 3 6 8 13 4 5 6 8 12 21 I seek Column B to show 1 2 3 4 5 1 2 3 4 5 6 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sequential numbering for tickets | Excel Discussion (Misc queries) | |||
Sequential numbering | Excel Discussion (Misc queries) | |||
sequential numbering of pages in a cell | Excel Worksheet Functions | |||
automatic sequential numbering in excel or word | Excel Discussion (Misc queries) | |||
How do I set up sequential numbering on labels | Excel Worksheet Functions |