count closest empty cells in a row
Hi
if in A1 is a value , b1 empty , c1 empty ,
in d1 my formula i need must return value 2 ( it found
2 empty cells column C to the left ) .
My database i have to update every day , is from A11 to A82160 ,
but never have the same edge , data can be for eg
in row A11 to AB11 , A12:M12 , A13:AD12 ,
row by row is randomly different ;
is there a way to can have a formula ?
the formula I will enter in the same column ,
from CS11 to CS 82170 .many thanks
|