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!
Bookmarks