Copy values to a different cell

  • Thread starter Thread starter Kanga 85
  • Start date Start date
K

Kanga 85

In C1 I want the formula (to be pulled down 100 rows), If A1>B1 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
 
Thanks David

David Biddulph said:
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.
Click to expand...
 
Back
Top