Tom Ogilvy wrote:
column C (start in C2) in each would be the formula

=TEXT(A2,"000")&"-"&TEXT(B2,"0000")

drag fill down column C in each sheet

In D2 of sheet1

=if(countif(Sheet2!C:C),C2)=0,"Unique","Match")

then drag fill down the sheet.


Now you can filter on column D of sheet1 using Data=Filter=Autofilter.
Select Unique

it was so close with Niek's suggestion and with this i got it working,
And it has shaved of a lot of time

Thanks both Tom en Niek