Reply to thread

Message: [QUOTE="Patient Guy, post: 3825653"] I am using Excel 2007. I got #value error at first and did not know what to do at first. So I did a bit-by-bit formula build-up: start with find() and then workup to more containing functions. It does come out. If you use an "evaluate formula" it reports that something is a constant when that is not the case (probably thinking the cell reference is not a cell reference). As for unmerging, that actually DOES produce a #VALUE error, as A19 attempts now to reference an empty A18. If I have to go in and fiddle with the formula, then I might as well just manually enter in the "M-N" format text (i.e. use no formula), since the idea of using the formula is to do a down-fill whenever I need to re-sequence items after an insert/delete row. [/QUOTE]