| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sequential numbering exceptions
Easy exception reporting of sequential numbering.
I had a lengthy complex sequentially numbered worksheet by row. Lots of things have now been added or taken away & I want a quick formulae to spot errors in the numbering so I can amend them. The reason I can't just copy & paste from row 1 to the end is that there are 3 levels - it goes something like this(with many more rows at each level!!): S01 level 1 allocation S0101 level 2 sub allocation S010101 level 3 sub allocation S010102 as above S010103 as above S0102 level 2 sub allocation S02 level 1 allocation Does this make sense? Does anyone have a solution please? I have about 50 worksheets of long coding to check! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sequential Numbering | Excel Discussion (Misc queries) | |||
| Sequential numbering by 6 | Excel Discussion (Misc queries) | |||
| sequential numbering | Excel Discussion (Misc queries) | |||
| PO with sequential numbering with start / end numbering | Excel Discussion (Misc queries) | |||
| Sequential numbering | Excel Discussion (Misc queries) | |||
Threaded Mode
