K
Ken
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
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