Hi,
take a look at CPearson web

http://www.cpearson.com/excel/MergeListsToDistinct.aspx

if this helps please click yes thanks

"Sonny" wrote:

Dear all,

Could someone help me here please.

Ive got two working sheets in exact same format. These two sheets have been
updated by two person.
Obviously, there are some duplicates.

The question is how could I merge those two sheets together and delete the
duplicates. (I know the traditional way is to sort them and delete it)
Is there any quicker way to do it?

Many thanks.