Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
My sheet is layed out like so:
A B 1 Jim 100 2 Dave 200 3 34 4 300 5 43 6 22 7 Steve 44 8 Jim 100 9 Dave 200 10 34 11 300 12 Al 43 13 22 14 Jim 44 I would like a function that would count the number of blank cells underneath the selected cell until the next filled cell. For example if I were to use this function on A2, it would return 4. On A9, it would return 2. Is there any formula that would do this? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Count Blanks | Excel Discussion (Misc queries) | |||
Count blanks in Data Validation | Excel Discussion (Misc queries) | |||
Count the blanks | Excel Worksheet Functions | |||
Count blanks cells | New Users to Excel | |||
Count Blanks in a Filtered Column | Excel Worksheet Functions |