| 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 |
| 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 | |||
Threaded Mode
