Is there a way to move the contents rather than just copy them? I don't mind
doing the formula per column.

So:

[putting formula in J2] if G2=11 move the contents of I2 to J2



"Bob Phillips" wrote:

You can't do it the way you want. A function can only return a result to the
cell it is in. For instance, in J2 you could say

=IF(G2=11,I2,"")

but the value would still be in I2 as well.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Soo" wrote in message
...
I need a formula to say:
if G2=10 keep contents of I2 in I2
BUT
if G2=11 move the contents of I2 to J2
BUT
if G2=12 move contents of I2 to K2

Can anyone help, please?