MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Reconciling (matching) 2 sets of data


Posted by DC on February 04, 2002 1:24 PM

I am trying to reconcile two sets of data (on the same worksheet or separate) where both sets of data share account number and price. I need to make sure that *both* account number and price match.

In a blank column I would like to be able to mark which rows of data have been reconciled and which have not. I need to mark reconciled rows for each set of the two sets of data.

Any ideas for any part of this task would be greatly appreciated.


Posted by Yogi Anand on February 04, 2002 2:05 PM

Hi DC:
I am not sure whther I have captured your scenario quite right, but in any event the approach I have used will apply, and you can adjust it to suit. The approach is depicted below:

A B C D E F G H
1 AcctNo1 Price1 | AcctNo2 Price 2 | Reconciled
2 AnaY1 525.45 | AnaY1 525.45 | TRUE <---- =AND(B13=E13,C13=F13)
3 JinA1 475.55 | JinA1 485.55 | FALSE
4 GanS1 670.50 | GanS1 620.50 | FALSE
5 WagC1 599.99 | WagC1 599.99 | TRUE

HTH

Yogi Anand
ANAND Enterprises (broken link)