Checking non-duplicates in column A across 2 sheets

[greek]

I have a workbook with 2 sheets. What I want is:

1. Cells in column A, Sheet 2 are compared with the Cells in column A, Sheet 1.

2. Sheet 3 is produced containing all the rows in Sheet 2 for which there is no duplicate cell in Column A, Sheet 1.

3. The rows copied from Sheet 2 to Sheet 3 are highlighted on Sheet 2.

Attached is a workbook with 3 sheets. Sheet 3 is the desired result (+ the cell highlighting on non-duplicates on Sheet 2).

[NBVC]

Insert a row above Row 1 in Sheet 2

Then in D2, enter formula:

=ISNUMBER(MATCH(A2,Sheet1!A:A,0))

copy down.

TRUE means an exact match was found....note one of those you said would match does not because of the lack of a dash in Sheet1...be aware of these...

Then select columns A:D in Sheet2 and go to Data|Filter|AutoFilter

select down arrow in column D and choose True.

Now copy those rows in Sheet3.

[greek]

Thanks, when I enter the formula I get: "The formula you typed contains an error".

http://img524.imageshack.us/img524/9...0902233747.png
http://img30.imageshack.us/img30/297...0902233800.png

[NBVC]

Try with ;

=ISNUMBER(MATCH(A2;Sheet1!A:A;0))

[greek]

Cool it works

Only that I have to select FALSE at the end to display non-duplicates.

[greek]

Is there any way to stop this macro from recalculating every time I make a change? It tends to recalculate very often and it becomes very slow in sheets with 60,000+ rows.