Merging Cells - lost of cell references

  • Thread starter Thread starter Greggers
  • Start date Start date
G

Greggers

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sharing workbooks limitations - Merged Cells 12
sorting two columns of merged cells 1
Formula from a single cell to a merged cell 4
VBA set thick borders around non empty cells in range 0
copy formulas over merged cells 2
Cell names of merged cells 1
Formulas in Merged cells 2
Automatically color merged cells 1

Back
Top