| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting Blanks with Conditions
Much easier to count the non-blanks and subtract this from the max possible.
-- Gary''s Student - gsnu200782 "Ken" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting Blanks with Conditions
Not quite sure I follow... can you give me a formula example?
Ken "Gary''s Student" wrote: Much easier to count the non-blanks and subtract this from the max possible. -- Gary''s Student - gsnu200782 "Ken" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting Blanks with Conditions
With A1 thru B15:
asdc 2 asdc 2 asdc 2 asdc 2 asdc 2 asdc 2 asdc asdc asdc asdc asdc 3 asdc 3 asdc 3 asdc asdc in another cell enter: =COUNTA(A:A)-COUNTA(B:B) which will display 6 the number of blanks in the region of interest. -- Gary''s Student - gsnu200782 "Ken" wrote: Not quite sure I follow... can you give me a formula example? Ken "Gary''s Student" wrote: Much easier to count the non-blanks and subtract this from the max possible. -- Gary''s Student - gsnu200782 "Ken" wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting Blanks with Conditions
Thanks ... that works. Finally I need to add some exclusion. Can I do the
following or will I need to use Someproduct? =COUNTA(('DATA (RAW)'!V:V)-COUNTA('DATA (RAW)'!BH:BH) *('DATA (RAW)'!N2:N5000<"SUPPORT REQUEST") *('DATA (RAW)'!N2:N5000<"WORK ORDER") *('DATA (RAW)'!AQ2:AQ5000<"ASIA") *('DATA (RAW)'!AQ2:AQ5000<"CALA") *('DATA (RAW)'!AQ2:AQ5000<"NA")) "Gary''s Student" wrote: With A1 thru B15: asdc 2 asdc 2 asdc 2 asdc 2 asdc 2 asdc 2 asdc asdc asdc asdc asdc 3 asdc 3 asdc 3 asdc asdc in another cell enter: =COUNTA(A:A)-COUNTA(B:B) which will display 6 the number of blanks in the region of interest. -- Gary''s Student - gsnu200782 "Ken" wrote: Not quite sure I follow... can you give me a formula example? Ken "Gary''s Student" wrote: Much easier to count the non-blanks and subtract this from the max possible. -- Gary''s Student - gsnu200782 "Ken" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting non blanks with SUMPRODUCT? | Excel Discussion (Misc queries) | |||
| counting blanks | Excel Worksheet Functions | |||
| Counting blanks, either 1, 2 or 3 | Excel Worksheet Functions | |||
| Need No Blanks List based on two conditions | Excel Worksheet Functions | |||
| Counting Blanks | Excel Worksheet Functions | |||
Linear Mode
