2 lists combined to make 1

[Tbone]

I have two lists (workbooks) of addresses. The lists (workbooks) have some
addresses in common. I'd like Excel to find those identical addresses and
create a 3rd list (workbooks) of the addresses in common. How do I do it?

 

[Eduardo]

Hi,
look CPeardon web, scrool down to the 2nd title

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

if this helps please click yes, thanks