Finding duplicates between two lists

Hi, Indi_Ra thank you for the answer, i have still got couple of questions still unsolved.

1. What if there are 300 rows for 3 coloumns A,B,C? FOR EXAMPLE:

  
A1  B1   C1
3     6    4
4     6    3
1     2    3
2     1    3

the outcome should be like this

   
D1  E1   F1
3     6    4
1     2    3

2. What if there are 300 rows for only 2 coloumns A,B?

Cheers