View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ken Ken is offline
external usenet poster
 
Posts: 590
Default Counting Blanks with Conditions

I have two columns that change in length (dynamically). What I need is to
count the blanks in Colunm B but the column length changes every day. Is
there a way to count only the blanks within the data and exclude normal cell
blanks? If an end of row reference is needed maybe I can use column A as a
guide because column A will always show a value of HP.

A
MANAGER_ORG_GROUP
HP
HP
HP
HP
HP
HP

B
REQ_COMPLETION_DATE
4/2/2008 9:00:00 PM
4/7/2008 9:00:00 PM
3/27/2009 12:23:00 AM

4/7/2008 9:00:00 PM
5/10/2008 11:00:00 PM