Comparing two columns in Excel

[Closed]
Report
-
Posts
2786
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
August 5, 2021
-
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.

1 reply

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!

Posts
2786
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
August 5, 2021
470
I have to agree here. This looks suspiciously like homework. Also, shouldn't the 101 value be 490?

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!