Comparing two lists of financial data
 

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.

Comparing two lists of financial data
 

NG Wrote:
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.


Try this, see attachement.


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

--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=504580