the easy answer is dont use merge as it is the worse thing you can do in a spreadsheet and will only cause problems

but you could use =COUNTA($B$1:B1)

Attached Files

How to get autonumber series if adjacent cell has merged cells_purfleet.xlsx (9.3 KB, 6 views)