Merge two columns of data with a condition

[Richard]

Hello,

I am trying to put information that is in two columns into a third column,
but I don't the two columns concatenated. If the same information is in both
columns then I want only the information in column 1 brought over to column
3. If information is only in column 1 or 2 then I want that information
brought over to column 3. When both columns have information, the
information will always be the same. Is there a function or formula that can
do what i want.

Thanks,

 

[Sam Wilson]

If A and B are your columns, put this in C1 and copy down:

=IF(A1=B1,A1,A1&B1)

 

[Lars-Åke Aspelin]

Hello,

I am trying to put information that is in two columns into a third column,
but I don't the two columns concatenated. If the same information is in both
columns then I want only the information in column 1 brought over to column
3. If information is only in column 1 or 2 then I want that information
brought over to column 3. When both columns have information, the
information will always be the same. Is there a function or formula that can
do what i want.

Thanks,

If the first column is column A, the second column is column B, and
the third column is column C, and the data starts on row 1 then try
the following formula in cell C1:

=IF(A1<>"",A1,B1)

Hope this helps / Lars-Åke