Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Merge two columns of data with a condition
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, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Merge two columns of data with a condition
If A and B are your columns, put this in C1 and copy down: =IF(A1=B1,A1,A1&B1) "Richard" wrote: 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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to merge two columns of data | Excel Discussion (Misc queries) | |||
How can I merge data in several columns in Excel or Access? | Excel Discussion (Misc queries) | |||
How do I merge 2 columns of numerical data? | Excel Discussion (Misc queries) | |||
How do I merge two columns without losing data? | Excel Discussion (Misc queries) | |||
How to merge rows of data in 2 columns into 1 col. | New Users to Excel |