Visit Chips site and look for his stuff on duplicates
http://www.cpearson.com/excel/duplicat.htm

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"via135" wrote in
message ...

hi all!

i am having data in 2 workbooks!
in workbook1 sheet 1 COL"A" contains cheque numbers & COL"B" contains
amounts as under

chqno amount
123456 100
234561 200
546326 300
123406 400
654896 300
689647 150
465721 200

in workbook2 sheet1 - same two columns as in workbook1 sheet 1
the records are the same with a few lesser than in workbook1 sheet1
also the records are not in the same order but shuffled randomly!
example as under:

chqno amount
689647 150
546326 300
465721 200
123456 100
234561 200

now i want to trace out the following missing 2 entries in the
workbook2sheet1!

123406 400
654896 300

help pl?!

-via135


--
via135
------------------------------------------------------------------------
via135's Profile:
http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=510173