Copy values to a different cell
 

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

Copy values to a different cell
 

A formula in C1 can not change the value in B1.
If in C1 you put the formula =MAX(A1,B1), you could then copy the result and
paste special values into column B.
--
David Biddulph

"Kanga 85" wrote in message
...
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

Copy values to a different cell
 

Thanks David

"David Biddulph" wrote:

A formula in C1 can not change the value in B1.
If in C1 you put the formula =MAX(A1,B1), you could then copy the result and
paste special values into column B.
--
David Biddulph

"Kanga 85" wrote in message
...
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