View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mal Mal is offline
external usenet poster
 
Posts: 17
Default 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