In C1 I want the formula (to be pulled down 100 rows), If A1B1 then
B1=value(A1), else B1 value remains unchanged. My attempts to do this have
all ended in failure. I could have this formula in column B, but I need to
see (and subsequently operate upon) the values, not the formula.

Thanks