Thread: compare 2 cells then copy value if they are different
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gwen B Gwen B is offline
external usenet poster
  
Posts: 1
Default compare 2 cells then copy value if they are different
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