Comparing two lists of financial data

N

NG

List A has an amount column and List B has an amount column. Both lists are
sorted by the amount column. I am looking to identify what amounts are in
List A and not in List B. I am also looking to identify what amounts are in
List B and not in List A. Both Lists may have an amount more than once
($100.00 could be on List A 10 times and $100.00 could be on List B 9 times -
doing this manually I get one $100.00 record on List A that is not on List
B). Is there anyway to automate this? Thanks.
 
M

Morrigan

NG said:
List A has an amount column and List B has an amount column. Both lists
are
sorted by the amount column. I am looking to identify what amounts are
in
List A and not in List B. I am also looking to identify what amounts
are in
List B and not in List A. Both Lists may have an amount more than
once
($100.00 could be on List A 10 times and $100.00 could be on List B 9
times -
doing this manually I get one $100.00 record on List A that is not on
List
B). Is there anyway to automate this? Thanks.
Click to expand...


Try this, see attachement.


+-------------------------------------------------------------------+
|Filename: Count.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4263 |
+-------------------------------------------------------------------+
 
Top