_:nf6471a6a0aba4b0a9f0dfe9cb3be23ecxb1
<http://schema.org/text>
"Hello, \r\n\r\nI have to compare the following 4 columns;\r\n\r\nCode  Amount    Code    Amount   \r\n100       213          101       25 \r\n101       465           102      35\r\n102       149           103       56\r\n\r\nColumn 5 should show the list of all codes by comparing column 1 & 3 and column 6 should show the summed up amount of column 2 and 4 as shown below.\r\n\r\ncode   amount\r\n100      213\r\n101      238\r\n102      184\r\n103        56\r\n\r\nPlease suggest a formula."
<https://ccm.net/forum/affich-1050810-comparing-two-columns-in-excel>