Counting blank cells between non-blank cells
Andy,
Try
=IF(SUMPRODUCT((A2:A101="")*(A3:A102<"")*(A1:A100 <""))0,"Coding error","All OK")
Note the slight offsets of the ranges...
HTH,
Bernie
MS Excel MVP
"AndyH" wrote in message
...
Does anyone know a simple way to count the number of blank cells between
non-blank cells? I have a column of data that in some cases has from zero to
five blank cells between non-blank ones. If there are not two blank cells
between the non-blank ones, it is an indication of a potential coding error
within the data source. I'm looking for an easy way to do my data scrub.
Any ideas would be helpful.
Thanks.
|