Thread: compare 2 cells then copy value if they are different
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
  
Posts: 2,819
Default compare 2 cells then copy value if they are different
And if the 2nd cell is NOT blank?

Gwen B wrote:
I want to compare two cells, 1 contains an address, the other may or may not
contain data. If the 2nd cell is blank I want to copy the address from the
1st cell. Is there a formula to do this?

Reply With QuoteReply With Quote