Edit Copy
Edit PasteSpecial Values

or

F2 F9 Enter

HTH


On Mon, 10 Oct 2005 14:34:05 -0700, Christina
wrote:

Thank you so much for your help. That definitely works.

By any chance do you also know how to make the result of the formula a value
so that I can delete the reference. So, below, I want to delete B2 but have
the contents in D1 remain.

Thanks, Christina


"BekkiM" wrote:

In D1, put the following formula:

=IF(A1=A2,B2,"")

That last "" takes care of the "else" part of your equation--in other words,
what to do in D1 if A1 does not equal A2.

"Christina" wrote:

2Please help with the syntax for the following:

If the contents in A1 = the contents in A2, put the contents of B2 in D1.

Thanks, ck

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________