hello,
i've a problem to find the unique record from two sheet. I've two sheets SHEET1 and SHEET2. SHEET1 contains 250 records (S.No., NAME, ADDRESS) alphabetically arranged (ascending) by NAME. SHEET2 contains 320 records (S.No., NAME, ADDRESS) which are also alphabetically arranged (Ascending).

Actually, SHEET2 contains 250 records same to SHEET1 and new 70 records. I've to obtain those 70 records from SHEET2. All records are arranged in alphabetical order so i can't obtain the distinct record from sheet2

Is this possible?

Waiting for help...