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

kingston123 · #1 06-28-2020, 07:53 AM

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.

Purfleet · #2 06-28-2020, 08:15 AM

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)

kingston123 · #3 06-28-2020, 08:35 AM

Quote:

Originally Posted by Purfleet

=COUNTA($B$1:B1)

What does first B & second B refer to?

What does 1 & second 1 refer to?

Pecoflyer · #4 06-28-2020, 09:12 AM

Check the Net about "absolute" and "relative" cell references

Use merged cells effectively

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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