How to obtain unique records

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...

Hi,

Use a couple of helper columns on sheet 2 and a single helper column on sheet1.

On sheet1, assuming the data is currently in columns A:C, add a new helper columns A, and in A1 enter the formula:

Please Login or Register  to view this content.

Then copy this down the whole of column A

On sheet2, assuming the data is currently in columns A:C, add two new columns A&B. In B1 enter the formula:

Please Login or Register  to view this content.

and in A1 on sheet2 enter the formula"

Please Login or Register  to view this content.

Now copy A1:B1 down all 250 rows

Now filter sheet 2 for the word 'New' in column A - these are the additional records.

This assumes the Names and addresses are in exactly the same format and spelt in exactly the same way, i.e. no extraneous characters.

HTH