Comparing two columns in Excel

-
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.
See more 

Your reply

1 reply

Posts
10940
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
December 14, 2018
0
Thank you
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!

TrowaD
Posts
2440
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 13, 2018
-
I have to agree here. This looks suspiciously like homework. Also, shouldn't the 101 value be 490?
Respond to ac3mark