Merge two columns of data with a condition

  • Thread starter Thread starter Richard
  • Start date Start date
R

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,
 
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,
Click to expand...


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
 
Back
Top