Overlay

  • Thread starter Thread starter Microsoft
  • Start date Start date
M

Microsoft

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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?
|
|
 
Back
Top