Microsoft Office Forums - View Single Post - How to get autonumber series if adjacent cell has merged cells?

Thread: How to get autonumber series if adjacent cell has merged cells?

View Single Post

Old

06-28-2020, 07:53 AM

kingston123 kingston123 is offline

kingston123 is offline

kingston123 uses Windows 10

Windows 10 kingston123 uses Office 2013

kingston123 uses Office 2013

Office 2013

Advanced Beginner

The original poster

Join Date: Sep 2018

Posts: 85

kingston123 is on a distinguished road

Default

How to get autonumber series if adjacent cell has merged cells?

In place of (5,6,7,8) I should have 5 because adjacent cell has merged cells.

In place of (13,14,15.....20) it should show "10" because adjacent cell has merged cells.

Reply With Quote