We help IT Professionals succeed at work.

reconcile data

60 Views
Last Modified: 2017-04-05
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!
Comment
Watch Question

Managing Director/Excel VBA Developer
CERTIFIED EXPERT
Distinguished Expert 2018
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Excellent
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.