Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CountBlank with a reset?
Hey all,
I currently have a running list in columns B-S. The cells either contain an 'x' or is blank. What I've looking for is a formula that will count the blank cells in a column, but reset once a 'x' is given. then re-start counting the blank cells once it occurs again. ex. ColumnC x x <----- here it would show "4" as its been blank for 4 rows x <----- count resets due to it not being blank. x <----- here it would have reset to "2" as it's currently been blank for 2 rows Thanks in advance! Matt |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countblank formula | Excel Worksheet Functions | |||
COUNTBLANK MAX question | Excel Discussion (Misc queries) | |||
COUNTBLANK function | Excel Worksheet Functions | |||
COUNTBLANK function | Excel Worksheet Functions | |||
COUNTBLANK function | Excel Worksheet Functions |