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" <(E-Mail Removed)> wrote in message
news:c7957fbc-7062-41cc-928b-(E-Mail Removed)...
>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