Comparing two columns in Excel

sham - Jun 21, 2018 at 06:34 AM - Latest reply: TrowaD 2438 Posts Sunday September 12, 2010Registration dateModeratorStatus October 16, 2018 Last seen
- 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.
See more 

Your reply

2 replies

ac3mark 10668 Posts Monday June 3, 2013Registration dateModeratorStatus October 17, 2018 Last seen - Updated by ac3mark on 21/06/18 at 08:37 PM
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 2438 Posts Sunday September 12, 2010Registration dateModeratorStatus October 16, 2018 Last seen - 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?
Respond to ac3mark