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

Have a look at Chip's stuff about duplicates on www.cpearson.com
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Abdul" wrote in message
...
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