2 lists combined to make 1
 

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?

2 lists combined to make 1
 

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

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

if this helps please click yes, thanks

"Tbone" wrote:

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?