If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to count merged cells
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. |
#2
|
|||
|
|||
How to count merged cells
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" wrote in message ... 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. |
#3
|
|||
|
|||
How to count merged cells
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. |
Thread Tools | |
Display Modes | |
|
|