Prev: SUMIF Function
Next: Alphabetizing
From: Excel Ella on 8 Apr 2010 19:43
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.
From: "David Biddulph" groups [at] on 9 Apr 2010 12:01
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.
--
David Biddulph


"Excel Ella" <ExcelElla(a)discussions.microsoft.com> wrote in message
news:E60F0B1D-FB18-4864-95A2-9CD98CF9441E(a)microsoft.com...
> 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.


From: JLatham on 9 Apr 2010 17:28
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.

"Excel Ella" wrote:

> 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.
 | 
Pages: 1
Prev: SUMIF Function
Next: Alphabetizing