View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Excel Ella Excel Ella is offline
external usenet poster
 
Posts: 4
Default 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.