If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
compare 2 cells then copy value if they are different
If, in addition to what you have specified, when the 2nd cell is not blank
you want to use the value from the 2nd cell, then try =IF(B2="",A2,B2) or =IF(B2"",B2,A2) -- David Biddulph "Gwen B" Gwen wrote in message ... 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? |
#4
|
|||
|
|||
compare 2 cells then copy value if they are different
it is not possible without an auxiliar column, assuming the formulas that
David sugest you but using it on column C. or you must to type a different formula in each cell to preserve original values on column B. hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Gwen B" escreveu: 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? |
Thread Tools | |
Display Modes | |
|
|