With a little tweaking for your specific scenario, one of these should help:
http://www.cpearson.com/excel/Duplicates.aspx

http://www.contextures.com/xlFunctions02.html


Regards,
Ryan--

--
RyGuy


"Sanjib" wrote:

I have 10 names in sheet1, 15 names in sheet2 out of which 4 are same as
sheet 1.
Now I want to display the names of remaining 6 persons of sheet1 and 11
persons name of sheet2 in sheet3