Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare and Copy | Excel Discussion (Misc queries) | |||
compare and copy | Excel Discussion (Misc queries) | |||
Compare and copy | Excel Discussion (Misc queries) | |||
How do I compare cells and if FALSE compare to next cell in EXCEL | Excel Worksheet Functions | |||
Compare and copy | Excel Worksheet Functions |