Hi

I have a excel file in sheet 1 containing 45000 records of names , unique No , etc. In sheet 2 have similar 28450 records (sheet 2 records are subset of sheet 1 records with same header). I want to do advanced filter in sheet 1 for records, which are not in sheet 2(by taking Unique No. header for filter criteria).

Please assist

MURUGANAND