Hello,
(Using Excel 2007)
I have a column of numbers in a sequence, for example 1,2,3 up to 10.
If for example I merge the two cells with 5 & 6 in them, the 6 is lost and
the sequence is broken.
What formula could I use in each cell which would re-calculate the sequence
should further cells in the column be merged?
I have tried simple A1+1 etc formula, but with the lower cell reference lost
due to the merge, this type of formula fails.

Any suggestions please.

Many thanks