http://www.cpearson.com/excel/duplicat.htm

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Graham56" wrote in message
...
I have 2 lists & I would like to be to identify data that is in both lists
so
that I can delete non relevant data & then combine the data from the 2
lists
into one list