Lets say I have a row with the following numbers. 00110100011111100011

Each number is in its own cell. I will wish to do some computations on only the zeros. What I need to do is to be able to find the address of the zero to the left that is the closest in this series for each and ever cell.