| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Maximum Number of Blank Cells between Non Blank Cells in a Range
I am trying to count the Maximum Number of Blank Cells between Non Blank
Cells in a Range. e.g. Range A1:a13 a1 - 2 a3 - blank a4 - blank a5 - 24 a6 - blank a7 - 7 a8 - 51 a9 - blank a10 - blank a11 blank a12 - blank a13 - 6 The answer is 4. Cells a9 to a12. Any help appreciated. Thanks, Mal |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fill Blank cells in a range | Excel Discussion (Misc queries) | |||
| Hide row if all cells in another range are blank | Excel Discussion (Misc queries) | |||
| clear range of cells if another becomes blank | Excel Worksheet Functions | |||
| Range object without blank cells | Excel Discussion (Misc queries) | |||
| How do I skip blank cells when copying over a range of cells? | Excel Discussion (Misc queries) | |||
Threaded Mode
