Hi,

I'm looking for a macro to add the values in two columns based on a criteria

Below is the data how I want it

Identifier Suffix Amount 1 Amount 2 Match Result
000000001 C 0.00 (30.77) Yes
000000001 C 30.77 0.00 Yes
000000002 B 0.00 (71.17) No
000000002 B 0.00 (71.17) No


There are four columns, the identifier and Suffix should match and then it should add the values in Amount 1 and Amount 2 or Amount1 only or Amount2 only (whatever the case may be), and show result in Match Result column indicating a Yes or No.

Any help would be greatly appreciated!!

Thanks in advance!