Comparing two columns in Excel

Closed
sham - Updated on Jun 21, 2018 at 07:13 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 26, 2018 at 11:48 AM
Hello,

I have to compare the following 4 columns;

Code Amount Code Amount
100 213 101 25
101 465 102 35
102 149 103 56

Column 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.

code amount
100 213
101 238
102 184
103 56

Please suggest a formula.
Related:

1 response

What is in it for us? This sounds like homework!

Those who post need to understand, if you really want help, you have to SELL IT! YOU need to have as much ownership as us, so try to explain what is the situation. We will then understand, and care a little more. With posts such as this, it sounds like challenge, and not a real problem, as there is NOTHING behind it but an answer!

0
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Jun 26, 2018 at 11:48 AM
I have to agree here. This looks suspiciously like homework. Also, shouldn't the 101 value be 490?
0