I have two Excel spreadsheets. One contains a list of random email addresses
(perhaps 100) that is extracted from another far more comprehensive list
that includes address and contact details (perhaps 50,000). I would like to
create a function/macro to overlay/highlight which items in the larger list
are included in the smaller list. Any ideas?
Look here:
http://www.cpearson.com/excel/listfunctions.aspx

Signature
Kind regards,
Niek Otten
|I have two Excel spreadsheets. One contains a list of random email addresses
| (perhaps 100) that is extracted from another far more comprehensive list
| that includes address and contact details (perhaps 50,000). I would like to
| create a function/macro to overlay/highlight which items in the larger list
| are included in the smaller list. Any ideas?
Microsoft - 18 Sep 2007 09:06 GMT
Perfect solution!!!Thanks
> Look here:
>
[quoted text clipped - 8 lines]
> list
> | are included in the smaller list. Any ideas?