Copy first columns A1 to B3147 (or whatever amount of lines there is)
from Sheet 1 and paste them into Sheet 3!A1. The data will then lie in
the same block as in Sheet 1.
Then copy A1 to B8116 ( or whatever amount of lines there is in this
sheet) from Sheet 2 and paste them into Sheet 3 below the first ones.
In this example they will lie in the block from A3148 to B11263.
In C1 write =IF(A1=A2;A1;""). Perhaps you must use comma instead of
semicolon
Copy C1 all the way down and include also column D
Sort column A and B by A and you will see all the A duplicates in
column C
Sort column A and B by B and you will see all the B duplicates in
column D
Niels
--
nsv
------------------------------------------------------------------------
nsv's Profile:
http://www.excelforum.com/member.php...o&userid=26500
View this thread:
http://www.excelforum.com/showthread...hreadid=478018