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

		Microsoft Office Forums > Microsoft Excel > Excel
How to get autonumber series if adjacent cell has merged cells?

FAQ

Thread Tools

Display Modes

06-28-2020, 08:15 AM

Purfleet

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

Office 2019

Expert

Join Date: Jun 2020

Location: Essex

Posts: 345

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, 8 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Borders on merged cells also appearing on unwanted adjacent cells	MrsC	Word Tables	2	08-19-2019 09:14 AM
Problem with merged cells and row height in adjacent two- and three-row columns	rolandoftheeld	Word Tables	3	08-31-2018 03:55 PM
Conditional formating all cells in an array based on adjacent cells	deejay	Excel	6	12-20-2016 12:00 PM
Table will not allow sorting because "cells are merged". I can't find the merged cells.	wendyloooo	Word Tables	1	05-26-2015 01:19 PM
How to conditionally format cells in Col. A if it matches adjacent cell in Col. B?	alshcover	Excel	2	06-03-2014 12:50 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:58 AM.