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

Many people here will advise you NOT to merge cells, and you have
found one of the reasons why. Is there a particular reason for wanting
to do so?

I suppose you could use a fomula like:

=MAX(A$1:A1)+1

in A2 with the number 1 in A1, and copy this down.

Pete

On Nov 28, 10:25 pm, Greggers
wrote:
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