Compare two Sheets

[Abdul]

I have data in two sheets, say names in column A

I want to compare them and generate a report in sheet 3 seperately
identifying that are not in other sheet.

something like
Column A name
Column B "Not in sheet2:
Column A name
Column B "Not in sheet1


Thanks

 

[Bernard Liengme]

Have a look at Chip's stuff about duplicates on www.cpearson.com
best wishes