I need the program to be able to do the following:
Step 1. Get numeric ID from column "B", shown right after "Name.ID:". Then check for all similar ID's in the same column, in case there are any, and sum up the amount(s) from column "A" for all those id's.
Step 2. Go to column "C" and find all similar numeric ID's that match ID in step 1, sum up the total from column "D" for all those ID's.
Step 3. Compare totals for id’s from step 1 and step 2 and flag out ID number and total amount, if there is a difference.
Continue this process for each unique ID.
Please help me with solution. Thanks!