Check out this site of Chip Pearson.

Scroll down to "D", and see all the options referring to duplicates.

http://www.cpearson.com/excel/topic.htm
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Prixton" wrote in message
...
Hi,
I have two lists, placed in two different sheets in the same workbook. Now
we want a new list that does only contain those items that are in both
lists.

Is there a way to do this?

Thanks in advance!