Hi,
I have what I hope is a small problem and since I only tend to use excel to
export to and for financial information I am a little stumped.

I have been given 2 excel sheets each with similar information (esentially
they are names and addresses) is there any way I can compare the 2 sheets by
surname with the result telling me which surnames in sheet 1 aren't in sheet
2?

Many thanks help is much appreciated

Michael