How to count merged cells

E

Excel Ella

Can someone help me in developing a formula that will:
1. Count how many merged cells in a column that are created from 2 cells
AND contain both text and numbers?
2. Count how many merged cells in a column that are created from 3 cells
AND contain both text and numbers?
3. Council how may merged cells in a column that are blank.
 
D

David Biddulph

If you look in the archives of this group you will see countless examples of
reasons not to use merged cells.
To concatenate cells is fine, to merge is asking for trouble.
 
J

JLatham

The formulas just to count cells with either text or numbers (or text AND
numbers) is bad enough, but I don't even know of a worksheet function that
can tell you:
1) if a cell is merged or not
2) how many cells are merged to make the one troublemaker

My advice is to go back and take the time to unmerge the cells and use
"center across selection" for the horizontal alignment of them across however
many columns are required. Merging of cells that will be used in
calculations or referenced in VB code = BAD.
 

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

Top